SQL Server Performance Forum – Threads Archive

Another instance in production

There was a problem in production and I had to FTP previous day’s BAK file into development to find out the problem. (Don’t ask why I hadn’t have the BAK available in development. In fact, the FTP had failed on that specific day!! [B)][xx(]) I was wondering, is it a good idea to create another instance in the production and copy all the databases from default instance into the new instance every night? The new instance then would be available for support team to work on a database in case of any incident. What is Pros and Cons of this idea? CanadaDBA

It depends how confidential your data is and if it is ok then you can proceed to take advantage of Database backup and restore in this case or log shipping to accomplish the task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Satya,
Do you mean it is ok that I create another instance on the production server? CanadaDBA

Yes as long as that server is well equipped with resources. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Do I have to reboot the server after installing the second instance?
CanadaDBA

If I remember correctly I think you may need to reboot after applying service pack. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>