469,578 Members | 1,778 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Restoring a SQL Server 2005 database without the log - revisited

I know this has been discussed before, but my database is getting huge. Every night I restore backups of my databases to a report server. I don't need the logs, so after restore I detach the database and delete the logs. When I reattach, SQL Server creates new log files that are tiny. If I can do this, why do I need the log files in the first place? As it is, I have to stagger my database restores because I don't have room for the 400 GB of log files.

I know that if I backup my database with the no_log option, I will have to provide a log file for it to restore. This allows for online backups where the database is updated during the backup process. I don't do any updates to my database during the backup. Is there any way to flag the backup file as not needing a log file? There should be no uncommitted transactions in the backup. Would taking my database offline during the backup help?

Thanks
Jul 22 '08 #1
2 1437
ck9663
2,878 Expert 2GB
You'd rather have and not need it, then not having it and you really really need it.

-- CK
Jul 23 '08 #2
After restoring the database on the report server, I set it to be read-only. How could I need the log file?


You'd rather have and not need it, then not having it and you really really need it.

-- CK
Jul 23 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Edwinah63 | last post: by
1 post views Thread by Robbert van Geldrop | last post: by
3 posts views Thread by jai | last post: by
5 posts views Thread by Troels Arvin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.