Re: Restoring sql server database from one server to another from a ba

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/16/04


Date: Fri, 16 Jul 2004 19:23:06 -0400

Have a look at these as well.

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

http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues

-- 
Andrew J. Kelly  SQL MVP
"Jack" <Jack@discussions.microsoft.com> wrote in message
news:1F88E2DF-A16D-4462-B55B-15E04F63F812@microsoft.com...
> Hi,
> I got a backup of a sql server database. I need to restore it to a
different server where few important databases are running. I need to make
sure those are operationa at any timel. What should be the strategy to
restore the backed up database in the new server? Thanks .
> Regards


Relevant Pages

  • Re: How to upgrade MSDE databases to SQL Server Databases
    ... First however we are going to permute the install sequence on a 'web ... farm' parameter and then permute a server target on the WSS Web Admin ... between Microsoft Access, MSDE, SQL Server Express and SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Backup issues after changing administrator name
    ... I set the relevant sql server databases to simple and ... You back up data from a volume that contains a Microsoft SQL Server ... > As creating the volume shadow copy failed, the open files shown in the log ... > CSS (Customer Support Service) for the following hot fix. ...
    (microsoft.public.windows.server.sbs)
  • Potential issue with DTS and Log Shipping
    ... My set up involves three SQL Server Databases. ... copy of first via log shipping. ... have a DTS packagage that that copys select ...
    (microsoft.public.sqlserver.dts)
  • RE: moving to a new server
    ... http://www.support.microsoft.com/?id=224071; Moving SQL Server Databases ... Errors After Restoring Dump ... for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Restore sql7 without .bks file
    ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Errors After Restoring Dump ... for SQL Server ... > databases from previous so we only need to do a restore but can not access ...
    (microsoft.public.sqlserver.setup)