CODEWITHSUNDEEP
sqlsql-server-2008database-backups
HMcompfreak
HMcompfreak

Reputation: 171

copying sqlserver2000 database from one computer to sqlserver 2008 of another computer

i have a database named SAHS in my desktop having sqlserver 2000 installed i want to copy it in my laptop(64bit) having sql server 2008 .. i tried removing a backup of it..

like this ;

BACKUP DATABASE SAHS
TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\BACKUP\SAHSFullRM.bak' 
WITH FORMAT;
GO

can i copy the backup file in my laptop and use the restore statement?.. if yes please show the restore statement im getting error in this :

restore database SAHS 
from disk = 'C:...'

saying operating system error. is there any other simpler way to do so..pls help

Upvotes: 0

Views: 573

Answers (2)

HMcompfreak
HMcompfreak

Reputation: 171

i did it myself .Open sqlserver management studio ,from the object explorer expand database column, right click any databse , select task --> restore --> database or Files or Filegroups , restore dialog box opes , write the new name of yor database in To Database , select location and type it in From Device option , select the checkbox , and click on OK .. ITS DONE .. this is a new feature in sqlserver 2008 ..

Upvotes: 0

John Dewey
John Dewey

Reputation: 7093

Make sure the target server has access to the folder containing the bak file. And on the target server you can try running the Restore Database wizard from SSMS.

Upvotes: 2

Related Questions