Re: Restore database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 09:05:19 -0500

It is stating that you need to specify new directories of where the files
will reside and to do this you use the WITH MOVE option of the restore
command. You can find details in BooksOnLIne under RESTORE. Also check out
these:

http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server 

-- 
Andrew J. Kelly  SQL MVP
"rudy" <rudy@discussions.microsoft.com> wrote in message 
news:FAF87ED3-D23E-47BB-A4BE-2EF93BDDF0F9@microsoft.com...
> I'm new to sql. i need to restore a data base that was in one server to
> another server. but when i try to do it i get obdc error 42000. i'm using 
> sql
> 2000. the error states that i should use move instead of restore. our old
> server died during the holidays and i'm setting up the new one. the old
> server was 2000 the new one is 2003.
>
> i thought that restoring the backup of the data was going to be easy.
>
> if any one has any suggestions please let me know.
> tia.
>

Relevant Pages

  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Two Disaster Recovery Questions
    ... I support the Professional Association for SQL Server ... > recovery site ... > second restore at the recovery site. ...
    (microsoft.public.sqlserver.server)
  • Re: Cant restore master db!!
    ... I tried starting the server as you & Hari instructed; the server started in single user mode. ... the restore has to be issued from the Veritas software interface. ... SQL Server returned the following error message: ...
    (microsoft.public.sqlserver.server)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)