June 4, 2002 at 11:23 am
I currently have this setup for my SQL Server 7.0 environment:
Work Place Production:
SQL Server 7.0
Off-Site Standby Server:
SQL Server 7.0
I have nightly replication from production to standby site for all our SQL Server 7.0 Full Database backups. In the event of a diaster, I would go to our off-site and restore master, system databases, then all user databases. This procedure is flawless with SQL Server 7.0 at both locations.
Now, I have this running also:
Work Place Production:
SQL Server 2000 ENTERPRISE EDITION
Off site Standby Server:
SQL Server 2000 STANDARD EDITION
PROBLEM:
A 2000 Enterprise edition MASTER will not restore to a 2000 Standard MASTER. (Version error when restoring). BUT, 2000 Enterprise USER databases will restore to 2000 Standard Server.
- Are these User databases O.K. here?
- Can I say there are recoverable in a diaster situation?
- Are there any issues?(structure, logins, etc)
.
June 4, 2002 at 11:24 am
Nightly Replication at the O.S. level - ARCServer.
June 4, 2002 at 5:13 pm
The logins and their associated passwords will not exist on the other server as this is located in master and you may need to run sp_change_users_login with autofix to connect the accounts properly between master and the DBs. Other than that I know of no issues.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 4, 2002 at 7:06 pm
So is it O.K. to restore User databases to another server(a standby server) FROM a 2000 Enterprise Edition to a 2000 Standard Edition without bringing over the Master?
(Just the login issue)
June 5, 2002 at 5:04 am
Ok I had a chance to research a bit this morning, see http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q268361 which is titled "INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL 2000 Standard Edition (Q268361)" and will be helpfull in pointing out other issues.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply