Have got a database on cd which i dump on my labtop. Have tried to restore it as a new database in SQL Server 2000 but keep having a device activation error which also says i should use WITH MOVE to identify a valid location for the file. The origional database is also in SQL Server 2000. Not sure if i was able to extract it correctly on to my labtop from the cd (i used Winzip). Any ideas guys!!
2006-12-27 15:52:21 · 3 answers · asked by red 1 in Computers & Internet ➔ Programming & Design
hey.
if you backup the db from one sql server
and copy it you should copy both the db file and the log file
only then you can restore it over the other machine
and if you find still problem
create a new db and the import this backup db into that
there are lots of ways to do it..
chat with me at sweetraskels@gmail.com
i can help you if you have more doubts
2006-12-27 15:56:11 · answer #1 · answered by sweetraskels 4 · 0⤊ 0⤋
If you have a backup file on your CD, then in Enterprise Manager, right click on Databases, All Tasks, Restore Database. If you have the .mdf and .ldf files on your CD, then instead of Restore Database, choose Attach Database. Always visit support.microsoft.com for these questions.
2006-12-28 00:34:47 · answer #2 · answered by digital_gaia_net 2 · 0⤊ 0⤋