Re: Backing up and restoring database to remote server
From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 02/24/04
- Next message: Delbert Glass: "Re: Sorry for repeating my Q but I hardly got any response yesterday"
- Previous message: Khurram Chaudhary: "Dynamic Search Conditions"
- In reply to: Fox: "Backing up and restoring database to remote server"
- Next in thread: JBLi: "Re: Backing up and restoring database to remote server"
- Reply: JBLi: "Re: Backing up and restoring database to remote server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 15:37:40 -0500
Your best bet is to have the Old Host do a FULL database backup using the
SQL Server Backup command and send you that file. From there you can
restore it n the new server. You will have to recreate the Logins but these
links should help:
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 "Fox" <fox @ connexions .net> wrote in message news:OVc$vmw%23DHA.3032@TK2MSFTNGP10.phx.gbl... > Hi, > > Thanks in advance to anyone who looks at > thia. > > My scenario is simple. I have a new client > who I will transfer from one WSP to another > WSP. My question is how best to transfer > their SQL database? I have Enterprise access to > the new host, but not to the old host. The > old host is freaky about security and surely > will not let me do anything on their sever. > My question is can I have the old host backup > the database and then I would restore the database > on the new host's server? The old host copied > the database data by dumping it into an ACCESS > file. Can I import the ACCESS database to create > the database on the new host and then restore a > backup of the database from the old host in order > to have all things in tact? If this will work, please > let me know what things to watch out for? I am > guessing the first thing might be to make sure the > new database has the same name as the backed > up database, or will that not matter? > > I do not have experience with CREATE DATABASE. > I do not know if that would be the way to do this, > but since I do not know how to work with that > I am asking this other scenario. But I am open > to any input or suggestions. > > Thanks for your time, > Fox > >
- Next message: Delbert Glass: "Re: Sorry for repeating my Q but I hardly got any response yesterday"
- Previous message: Khurram Chaudhary: "Dynamic Search Conditions"
- In reply to: Fox: "Backing up and restoring database to remote server"
- Next in thread: JBLi: "Re: Backing up and restoring database to remote server"
- Reply: JBLi: "Re: Backing up and restoring database to remote server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
