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

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
1. Copy the backup files to the new server.
2. Backup the current databases on the new server. (Just in case something
bad happens. <wink>)
3. Using SEM (SQL Ent. Manager) to restore the files. Be careful about
where the files will be stored, they may be different than where they were
backed up from.
4. If the DBO is not the owner of all objects in the newly restored
databse, you must ensure that the Logins associated with those users exist
in the new SQL Server and that they map properly to the newly restored user
database. If they don't, then create the logins, then use
sp_change_users_login (Check the BOL for more info on that command.).
Once you have successfully installed the new database, mapped users etc.
Create a new backup of that database.
Enjoy
Rick Sawtell MCT, MCSD, MCDBA
"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
|||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/scri...p?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