469,330 Members | 1,271 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,330 developers. It's quick & easy.

Restoring from Backup without logs

GM
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!

Aug 13 '07 #1
1 4710
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....626d528f12287c

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!
Aug 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Edwinah63 | last post: by
6 posts views Thread by paul | last post: by
3 posts views Thread by rdemyan via AccessMonster.com | last post: by
1 post views Thread by Robbert van Geldrop | last post: by
5 posts views Thread by Troels Arvin | last post: by
10 posts views Thread by Michael Hoffmann | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.