please help: restore database

[smsinger3]

Hello all. I am having a hard time restoring a database in SQL Server 7. I do a full backup of a database on one prodution server, then copy that backup file to another test server and try to restore it. I get an error saying that I don't have enough room to restore the database. I believe it's also trying to restore the transaction log along with the free space that it has allocated. The transaction log is only 33mb, but the transaction log free space is 1.5gb (huge!). I would have plenty of space if all the transaction log free space was not allocated! I don't need all this free space because all I'm doing is running queries against the new database. Is there a way to restore only the data and not the log?

Thank you in advance for your help!

Steve
sms@hmbnet.com

 

[foxdev]

Try using the FILE= option of the RESTORE command to do a file restore rather than a pure database restore. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org