Hello
We are using SQL Server 2005 EE in Production and Staging Datacenters. We are planning to set up LS between Prod XXX DB and Staging YYY DB.
1. IF Secondary DB is not with the same name of Primary any conflicts for restore?
2. If Primary DB has data drives different than secondary db, any issues with file and file systems in LS?
3. ANY Open issues related to LS
Please advice and give us sites and links to watch this LS scenario. Thanks
refer this link,http://sql-articles.com/articles/lship/lship.htm
1. No, primary db and secondary db can be with different names.
2. That should not be a problem
3. Ensure that the recovery model is Full for your db
But in database mirroring the principal db and secondary db need to have the same name......
ensure that there is sufficient privileges for the service accounts in primary and secondary servers for the shared folder as mentioned in the above link.....
No comments:
Post a Comment