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!
GM,
See my recent entry under "Restore database with no log". From what I
just went through, I think that your first and best option is to
tell the database owner/administrator to do a backup of the
transaction log, shrink the file and then send you
another backup. If you can't do that, you'll have to find a server
with enough disk space (NTFS, not FAT) to
on which to restore your backup so that you can shrink the logs
yourself. See Erland's advice to me on this matter.
http://groups.google.com/group/comp.databases.ms-sqlserver/b rowse_thread/thread/45fc181386acc8e1/50626d528f12287c#50626d 528f12287c
Bill E.
GM wrote:
> 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!