Re: Restore Master DB to New Server
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/24/04
- Next message: Hari: "Re: sp_attach_db error"
- Previous message: Tibor Karaszi: "Re: Restore Master DB to New Server"
- In reply to: Tibor Karaszi: "Re: Restore Master DB to New Server"
- Next in thread: Cory: "Re: Restore Master DB to New Server"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Mar 2004 23:28:04 +0100
Also, check put below KB articles:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in message news:e3qbJ6eEEHA.2460@TK2MSFTNGP10.phx.gbl... > The first thing you need to consider is whether the system databases are on the same path. If they are, then > SQL Server should start. If not, then SQL Server will not even start as it looks for model (which isn't in the > mast as stated in master..sysdatabases) and since model isn't there, it can't create tempdb and SQL Server > cannot live without tempdb. > > If the system databases are on the same path, all you need to do for your user database is to drop them (they > are suspect anyhow) and then try to attach to the database files using sp_attach_db. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > > > "Cory" <Cory.ellingson@rcis.com> wrote in message news:0BD2AFC2-6EF6-4C7D-BC29-D99D37BE9FFE@microsoft.com... > > Hello, > > > > I am trying to restore my databases to a new server for a BCP Drill, and I am running into a few issues. > > > > When I try to restore the master (in single user mode -c -m), that appears to go well, however, when I try > to start SQL Server back up, it gives numerous error messages, stating the \\..\dbname.mdb and .log are not > there, when infact, they are not there. However, I am trying to restore. From what I can tell, restore the > master, then the user DB's...another possible kink is that the .mdb's and the .log's are on different drives > (F & G)... > > > > Ideas? > > > > Cory > >
- Next message: Hari: "Re: sp_attach_db error"
- Previous message: Tibor Karaszi: "Re: Restore Master DB to New Server"
- In reply to: Tibor Karaszi: "Re: Restore Master DB to New Server"
- Next in thread: Cory: "Re: Restore Master DB to New Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
