sqlserver7 backup and recovery, ME! Thank you help! !

Category: MS-SQL Server -> Applications Author: spring_hold Date: 2010-11-05 09:48:29
 
spring_hold
2010-11-05 09:48:29
How to restore the machine back out SQLSERVER7 other machines backup file
steps how?
Please enlighten me! Thank
hf6868
2010-11-05 09:58:23
If it is a backup file, as follows:
If ENTERPRISE MANAGER resume, the specific steps are as follows:
1, open ENTERPRISE MANAGER, expand to DATABASES.
2, right click on the DATABASES "All Tasks" selected "RESTORY DATABASE"
3, in the GENERAL tab select "FROM DEVICE", then click on "SELECT DEVICE"
4, in the window that appears, click the "ADD", and then in the window, select "FILE NAME", click the ... button
5, select the backup file you created, you can succeed.
If using SQL statements, I will pass *. mdf establish a database, as follows:
first create a database with the same name as the original database, LOGIN, then the DATA folder *. mdf, *. ldf delete your previous backup *. mdf test to the DATA folder, and then use the SQL statement:
exec sp_detach_db @ db_name = 'dbname',
; 'c: \ Program Files \ Microsoft SQL Server \ MSSQL \ Data \ example.mdf',
exec sp_attach_single_file_db 'dbname',
'c: \ Program Files \ Microsoft SQL Server \ MSSQL \ Data \ example.mdf ',

zhuchaosuperman
2010-11-05 10:14:10
you first try to restore it, I guess may be wrong
czjyll0464
2010-11-05 10:25:40
above a lot of this post, they can search about
yinyue1008
2010-11-05 10:44:06
will be re-set in your original user login error
ComputerGirl100
2010-11-05 11:04:03
Thank DONGDONG and upstairs Brother
already fixed up