Friday, March 23, 2012

I can't restore my master DB

I have 2 servers (Prod & Staging)
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up
databases to the staging server from the production one.
---
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be
restored because it was created by a different version of the server (13421
8407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
> ---
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>|||I figured out the problem. A network guy implemented a security fix that alt
ered the version on the production box and he didn't implement the same fix
on the Staging box.
"Gregory A. Larsen" wrote:

> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> up databases to the staging server from the production one.
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
>
>

No comments:

Post a Comment