May 15, 2006 at 9:28 am
Just a quick question.
Our LIVE servers are set to FULL recovery model, as they should be.
One of our overnight jobs, is to restore the full backup to multiple servers for development, testing and reports.
Now for these servers we do not want full recovery model, only simple. If I do an ALTER DATABASE statement, do I need to restart SQL Services, or can I just go and do a truncate of the log and shrink the databases?
Thanks,
Graham
May 15, 2006 at 10:17 am
Just do an ALTER DATABASE mydb SET RECOVERY SIMPLE.
May 15, 2006 at 2:57 pm
Graham,
Have you considered leaving the dev and test databases in place and just refreshing the data using DTS? You wouldn't have to worry about changing the owner.
Greg
Greg
May 16, 2006 at 1:38 am
So does that mean that SQL Services do not need to be restarted?
Graham
May 16, 2006 at 8:06 am
Graham
Yes, it does mean that.
John
May 16, 2006 at 8:06 am
You do not have to restart SQL after ALTER DATABASE.
Have you looked at replication or log shipping? Unless a large percentage of the production database has been modified from one day to the next, restoring the full backups every day is probably overkill.
May 16, 2006 at 8:15 am
We are looking at Log shipping now, the problem is that I have only just gotten the change over from SIMPLE to FULL recovery model.
The full restore is a business requirement, so its one of those things.
I thought moving of the physical file locations with the ALTER DATABASE statement required a restart of SQL Services?
Thanks for the answers, has answered all my questions, much appreciated.
Graham
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply