August 30, 2004 at 3:04 pm
Hello Friends,
I got a quick question - we just merged with a new Prod and I have inherited managing a new DB. I tried to set up log shipping but the trans log backup failed - so looking at this new DB realized that they have this DB in Simple recovery - I want to change the recovery model to FULL. I also realized that the Auto Close is on.
Its been a while since I changed recovery models. Is this fairly safe to do and also does SQL Server need to restarted? I plan to make these changes tonight.
Thanks in advance
August 30, 2004 at 4:20 pm
These changes can be made without restarting and are painless. The main consideration is if the database is "owned" by a 3rd party application, making any changes could void the support agreement.
August 30, 2004 at 4:35 pm
Thank You.
Vik.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy