Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 system databases restore on different server

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-07-21 : 02:26:38
Hi All,

Why can't we restore the system databases among the database servers as we do it for Application databases.

What are the internal reasons behind we cannot migrate/restore system databases directly on a new server.

Thanks in Advance

Bea
Starting Member

7 Posts

Posted - 2010-07-21 : 10:38:32
Hello

System databases can be restored only from backups that are created on the version of SQL Server that the server instance is currently running.

Does this help, its from Books Online
Moving System Databases
http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
Go to Top of Page
   

- Advertisement -