RE: SQL 7 - moving server (HELP!!!!)
From: Ananth Padmanabham [MSFT] (ananthp_at_online.microsoft.com)
Date: 10/13/04
- Previous message: Hari Prasad: "RE: Using a .BAK File to Restore to a NEW SQL SErver 2000"
- In reply to: asim: "SQL 7 - moving server (HELP!!!!)"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 13 Oct 2004 02:18:58 GMT
Are you getting any errors when you perform RESTORE of the user databases?
As long as the user databases are valid and uncorrupted, you should be able
to restore them on any other SQL 7 box or even a SQL 2000 computer.
Regarding your question about the service packs: You cannot restore a
backup of a system database ( master , model or msdb ) on a server build
that is different from the build on which the backup was originally
performed. An attempt to perform such a restore causes the operation to
fail with errors. See the following KBs for more info:
PRB: System Database Backups Cannot be Restored on a Different Build of SQL
Server (KB 264474)
BUG: You receive an error message that contains a decimal representation of
the SQL Server version number (KB 824421)
Thanks,
Ananth Padmanabham
Microsoft SQL Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--------------------
| Content-Class: urn:content-classes:message
| From: "asim" <recursive@nas.net>
| Sender: "asim" <recursive@nas.net>
| Subject: SQL 7 - moving server (HELP!!!!)
| Date: Fri, 8 Oct 2004 14:55:49 -0700
| Lines: 47
| Message-ID: <1aa301c4ad81$92b294e0$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| thread-index: AcStgZKyMO0JD2IpRzq2GTSBBrMzbw==
| Newsgroups: microsoft.public.sqlserver.setup
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.setup:66916
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| Hello,
|
| I have a backup of all my databases (including 3 sys
| databases) from a NT 4.0 server, running SQL 7. The
| machine is nuked and I am trying to restore the databases
| on a Windows 2000 workstation, running SQL 7.
|
| I have followed the article (Microsoft Knowledge Base
| Article - 304692) 3 times already, even after re-building
| the master, because it nuked the master and the dbserver
| wouln't start. Last time I got to a point where after
| renaming the server (as per article; last step) I could
| see the databases in the Enterprise manager. However, it
| would only show the ones that were not restored and I
| could not even delete/drop them as they were not
| connected. These were old databases for which I do not
| have the back-up and not important. But, since they were
| on the old server and never deleted, they show up on the
| enterprise mgr and I cannot get rid of them.
|
| For the ones (user databases) that I tried restoring
| (Again, as per article, I used the following instructions
| to restore user databases) they do not show up in EM. I
| retartded the server and the entiore db tree in EM is
| empty.
|
| exec sp_detach_db N'mydb'
| go
|
| RESTORE DATABASE mydb FROM disk='d:\mssql7
| \backup\mydb_db.bak'
| WITH MOVE 'mydbdata' TO 'd:\mssql7\data\mydbdata.mdf',
| MOVE 'mydblog' TO 'd:\mssql7\data\mydblog.ldf',
| REPLACE
| go
|
| The only thing I am not sure about as to what service pack
| the old server was running (fopr SQL) when it died. this
| machine is running SP3
|
| Please help!!!
|
| you may send responses to recursive@nas.net
|
| thanks!
|
| Asim
|
- Previous message: Hari Prasad: "RE: Using a .BAK File to Restore to a NEW SQL SErver 2000"
- In reply to: asim: "SQL 7 - moving server (HELP!!!!)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
