<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Error .........While Restoring MASTER...
20 posts, Page 1 of 2
1
2
»»
Error .........While Restoring MASTER database
Rate Topic
Display Mode
Topic Options
Author
Message
Bhuvnesh
Bhuvnesh
Posted Tuesday, June 02, 2009 5:05 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562,
Visits: 3,451
hi
I have build a new Sql server Machine(64 bit )
i am restoring Master database ,
whose Backup has been taken just few seconds before restoring.
Its giving error :
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'master' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
The used script is :
RESTORE DATABASE [master] FROM
DISK = N'D:\REPORT_DEV\MSSQL.2\MSSQL\Backup\master_backup_20090602.bak'
WITH RESTRICTED_USER, FILE = 1, NOUNLOAD, STATS = 10
The Server is in SINGLE USE MODE
Please help
-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #727303
Adiga
Adiga
Posted Tuesday, June 02, 2009 5:18 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:50 AM
Points: 1,618,
Visits: 20,898
Try appending "REPLACE" in the restore command.
.... WITH RESTRICTED_USER, REPLACE ......
Pradeep Adiga
Blog:
sqldbadiaries.com
Twitter:
@pradeepadiga
Post #727318
MarkusB
MarkusB
Posted Tuesday, June 02, 2009 5:22 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:03 AM
Points: 4,218,
Visits: 3,874
Could it be that your backup device contains more than one backup?
I see you're using the option WITH FILE =1, which will restore the first backup which has been added to the device.
You can use RESTORE HEADERONLY to check what backups are in the file.
Markus Bohse
Post #727321
Bhuvnesh
Bhuvnesh
Posted Tuesday, June 02, 2009 5:29 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562,
Visits: 3,451
i modified the script and use WITH REPLACE option.
Script used:
Restore database [master]
from disk = 'd:\report_dev\mssql.2\mssql\master_backup_20090602.bak'
with replace
but this time i got new issue of "version mismatch"
Msg 3168, Level 16, State 1, Line 1
The backup of the system database on the device D:\REPORT_DEV\MSSQL.2\MSSQL\Backup\master_backup_20090602.bak cannot be restored because it was created by a different version of the server (9.00.3310) than this server (9.00.1399).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #727327
Adiga
Adiga
Posted Tuesday, June 02, 2009 5:34 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:50 AM
Points: 1,618,
Visits: 20,898
As suggested by Markus use "RESTORE HEADERONLY.." to verify that you are restoring from the right backup set. If you backup file has only one FILE, then you have to install the hotfix from http://support.microsoft.com/kb/959420 to bring this server to 9.00.3310. After that try restoring the master database.
Hope this helps !
Pradeep Adiga
Blog:
sqldbadiaries.com
Twitter:
@pradeepadiga
Post #727334
GilaMonster
GilaMonster
Posted Tuesday, June 02, 2009 5:44 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 37,669,
Visits: 29,923
Are you trying to restore a master database from a different server?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #727341
maechismo_8514
maechismo_8514
Posted Tuesday, June 02, 2009 5:45 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097,
Visits: 2,157
You cannot restore master database to a server which has different version. Both versions should be similar. As advised you should be able to upgrade it and then restore it with REPLACE command as the master datsbase already exists.
Post #727343
Bhuvnesh
Bhuvnesh
Posted Tuesday, June 02, 2009 5:48 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562,
Visits: 3,451
hi
yes from Different Server.
Following are the different versions
Backup taken from :
Microsoft SQL Server 2005 - 9.00.3310.00 (X64) Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Restore at server :
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #727345
GilaMonster
GilaMonster
Posted Tuesday, June 02, 2009 5:59 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 37,669,
Visits: 29,923
bhuvnesh.dogra (6/2/2009)
hi
yes from Different Server.
That's not a particularly good idea. There's a fair bit of stuff in master that's specific to the machine it was built on. Taking a copy from one server and restoring on another may give you some odd problems in the future (service accounts and built-in logins specifically)
What's your goal here?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #727357
Bhuvnesh
Bhuvnesh
Posted Tuesday, June 02, 2009 6:09 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562,
Visits: 3,451
Actually ,
currently we have low configuration MAchine
and now we need to clone the databases to High config Machine.
bascially replica of current one to new server .
-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #727363
« Prev Topic
|
Next Topic »
20 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
