Posted by GM on 08/13/07 21:53

We have received a backup file that is 6G in size. The log file is
about 74G while the MDF is about 5 G when we restored. Is there a way
to run a SQL script to restore the .BAK file without restoring the log
file as we do not have enough space on the server.

PS. We are running Sql2K5.

Thanks!

• Next in forum: Re: INNER JOIN - INSERT
• Prev in forum: Temp Table vs. Union: Which Has Better Performance?
• Thread view: Restoring from Backup without logs

[Reply to this message]