Hello,All:
I have two sql 2000 servers,one for production and the other is for backup server,I used the sql agent to create bakup daily in Sql server Enterprise Manager.
Now I want to import the backup data(generated by production server),I don't know how to do it.
Is it possible to do it ? anyone can give me a soluation ?
thanks in advanced!
->Open Enterprise manager of SQL Server 2000
-> Select Your Server
-> right click on your database
-> All Tasks -> Restore Database
-> Select from Device
-> click the button Select Devices
-> in the new window select Disk option
-> click add button
-> select your backup file in file name option
-> ok
->ok
->ok
No comments:
Post a Comment