June 7, 2006 at 2:07 am
When we transfer backup file one computer to another computer then
How to Add /restore backup file in a computer to the SQL SERVER 2000 ??.
AND
How to View these file when we restore the Backup file in a Sql Server 2000 in
Actually when restore backup file then they did not Show any thing ??
June 7, 2006 at 2:25 am
(1) If the database already exists on the destination server, make sure that nobody is using it and then right-click on it in Enterprise Manager. Otherwise, right-click on Databases.
(2) Choose All Tasks and then Restore Database.
(3) Make sure that the Restore as database field contains the name of the database you wish to restore.
(4) Click on From Device, then Select Device, then Add, then the ellipsis button (...). Navigate to the backup file then click on OK three times.
(5) On the Options tab, click on Force restore over existing database and change the physical file names and locations (if necessary) of the database files so that they are restored in the correct place on the new server.
(6) Click on OK.
(7) Use sp_helpuser to list the names of the users in the database. Delete them and recreate them (with the server logins if necessary) so that the SIDs match with the logins on the new server.
John
June 7, 2006 at 3:28 am
when we complete the restore procedure then HOW to See this Backup file which we store already??
June 7, 2006 at 4:22 am
I don't understand what you're asking. You can see the restored database under Databases in Enterprise Manager (you may need to refresh) and you can see the backup file in Windows Explorer.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply