Restoring the master

I getting a versioning error when trying to restore the master at our
disaster recovery site? The error I'm getting is below, any information
would be appreciated!
2004-01-29 14:43:43.61 spid51 Using 'xpstar.dll' version
'2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!This is an informational message, net an error.
Note that once the master database restore has completed, SQL Server will
shut itself down.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dave Brooks" <dbrooks@.neca.org> wrote in message
news:%2359brYq5DHA.1948@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I getting a versioning error when trying to restore the master at our
> disaster recovery site? The error I'm getting is below, any information
> would be appreciated!
> 2004-01-29 14:43:43.61 spid51 Using 'xpstar.dll' version
> '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

---

Restoring database to a different name and location

Can someone please tell me what's wrong with my script below? I am trying to restore a database backup to a different database name and location.

RESTORE DATABASE test
FROM 'C:\mybackup.bak'
WITH MOVE 'h_data' TO 'C:\Program Files\SQL2000\MSSQL\Data\Test_data.mdf'

Thanks

SHKWhat error are you getting?

I do the following

ALTER DATABASE TaxReconDB_Prod SET SINGLE_USER WITH ROLLBACK IMMEDIATE

RESTORE DATABASE TaxReconDB_Prod
FROM DISK = 'D:\Tax\BackUp\TaxReconDB.dmp'
WITH MOVE 'TaxReconDB_Data' TO 'D:\Database\NJROS1D151DEV\MSSQL$NJROS1D151DEV\Dat a\TaxReconDB_Prod_Data.MDF'
, MOVE 'TaxReconDB_Log' TO 'D:\Database\NJROS1D151DEV\MSSQL$NJROS1D151DEV\Dat a\TaxReconDB_Prod_Log.LDF'
, REPLACE|||The error said that I have a syntax error on line 2.

I tried

FROM DISK = 'C:\Mybackup.bak"

and I got an error "Cannot open backup device", which makes sense because the backup is not from a disk.

then I tried

FROM FILE = 'C:\MyBackup.bak"

and I got a syntax error.

Help. I am not familiar with restoring database at all.

Thanks

SHK|||The following is correct:

FROM DISK = 'C:\Mybackup.bak"

As you are getting "Cannot open backup device", looks like you have mispelled the file name or missed a blank or something...check again|||Check the ending double quote:::
FROM DISK = 'C:\Mybackup.bak"|||I double checked and the spelling is correct.

It is a single quote at the end of the FROM DISK.

I am out of ideas.

SHK|||Ok, do this

RESTORE FILELISTONLY FROM DISK = 'C:\...'

btw where is the back up file physically at?

What happend when you run

master..xp_cmdshell 'DIR C:\*.bak'

What do you see?|||I got it to work.

I copied the backup from the network to my C drive and wanted to restore the backup to my MSDE 2000. I was trying to run the script from the network when I got all those errors. I was playing around and figured that maybe I could try to run the script locally and there it ran.
I guess the script failed because the backup was on my C drive and I tried to run it from the network server.

Thanks for all the suggestions and helps.

SHK

Restoring database receives UNICODE error

Hi,
I am having problem while restoring database to another SQL Server. I
receives below given message. My both SQL Servers are 7.0.
MESSAGE
SQL DMO (ODBC SQL Stae 42000)
The database you are attmpting to restore was backup under a different unicode
Locale ID (1033) or Unicode Comparision Style 196609) Then the Unicode
Locale ID
1033 or Unicode comparion style 196611) Currently running on this server.
Backup or restore Operation terminating abnormally.
Ok Button.
MESSAGE OVER
Anyone who can solve this problem.
Nilkanth Desai
I think that although the error message is from ODBC the issue is in the
tool you're using. Perhaps you would get a better response posting to a
group with knowledge of the tools you're using - or to the SQL Server team
in general.
| Thread-Topic: Restoring database receives UNICODE error
| thread-index: AcXKdpDDNRh+0thOR76Cjqm0RNXUxA==
| X-WBNR-Posting-Host: 61.1.58.32
| From: "=?Utf-8?B?Tmlsa2FudGggRGVzYWk=?="
<NilkanthDesai@.discussions.microsoft.com>
| Subject: Restoring database receives UNICODE error
| Date: Thu, 6 Oct 2005 06:05:03 -0700
| Lines: 23
| Message-ID: <D3F9E543-916B-44A7-ACD4-AD3200C10CA6@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2822
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Hi,
| I am having problem while restoring database to another SQL Server.
I
| receives below given message. My both SQL Servers are 7.0.
|
| MESSAGE
| SQL DMO (ODBC SQL Stae 42000)
| The database you are attmpting to restore was backup under a different
unicode
| Locale ID (1033) or Unicode Comparision Style 196609) Then the Unicode
| Locale ID
| 1033 or Unicode comparion style 196611) Currently running on this server.
|
| Backup or restore Operation terminating abnormally.
|
| Ok Button.
|
|
| MESSAGE OVER
|
| Anyone who can solve this problem.
|
| Nilkanth Desai
|
|
|

Restoring database receives UNICODE error

Hi,
I am having problem while restoring database to another SQL Server. I
receives below given message. My both SQL Servers are 7.0.
MESSAGE
SQL DMO (ODBC SQL Stae 42000)
The database you are attmpting to restore was backup under a different unico
de
Locale ID (1033) or Unicode Comparision Style 196609) Then the Unicode
Locale ID
1033 or Unicode comparion style 196611) Currently running on this server.
Backup or restore Operation terminating abnormally.
Ok Button.
MESSAGE OVER
Anyone who can solve this problem.
Nilkanth DesaiI think that although the error message is from ODBC the issue is in the
tool you're using. Perhaps you would get a better response posting to a
group with knowledge of the tools you're using - or to the SQL Server team
in general.
--
| Thread-Topic: Restoring database receives UNICODE error
| thread-index: AcXKdpDDNRh+0thOR76Cjqm0RNXUxA==
| X-WBNR-Posting-Host: 61.1.58.32
| From: "examnotes"
<NilkanthDesai@.discussions.microsoft.com>
| Subject: Restoring database receives UNICODE error
| Date: Thu, 6 Oct 2005 06:05:03 -0700
| Lines: 23
| Message-ID: <D3F9E543-916B-44A7-ACD4-AD3200C10CA6@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2822
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Hi,
| I am having problem while restoring database to another SQL Server.
I
| receives below given message. My both SQL Servers are 7.0.
|
| MESSAGE
| SQL DMO (ODBC SQL Stae 42000)
| The database you are attmpting to restore was backup under a different
unicode
| Locale ID (1033) or Unicode Comparision Style 196609) Then the Unicode
| Locale ID
| 1033 or Unicode comparion style 196611) Currently running on this server.
|
| Backup or restore Operation terminating abnormally.
|
| Ok Button.
|
|
| MESSAGE OVER
|
| Anyone who can solve this problem.
|
| Nilkanth Desai
|
|
|