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

Question

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

Did you create a blank database on your laptop first? You might also need the WITH MOVE option of the RESTORE command if your directories are different on your laptop. — MikeJ-UK
– MikeJ-UK, Commented Mar 9, 2012 at 12:57
i tried this too , it showed me operating system error and restoring cancelled abnormally.i tried restoring with with move too — HMcompfreak
– HMcompfreak, Commented Mar 9, 2012 at 13:04
ok sir .. actually im a newbie so quite unaware .. but thnq for making me understand the reputation rate concept .. :) — HMcompfreak
– HMcompfreak, Commented Mar 9, 2012 at 13:26
Have you tried using the restore methods in the SSMS UI? It would be easier if we had more information regarding the error message (if there is a number, etc). But as John Dewey pointed out the most common error associated with a restore is that of permissions on the folder where the backup file is being stored. IF your full error says: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied)' then John is correct. — Robert Kaucher
– Robert Kaucher, Commented Mar 9, 2012 at 13:31

John Dewey · Accepted Answer · 2012-03-09 13:15:10Z

2

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.

edited Mar 9, 2012 at 13:15

answered Mar 9, 2012 at 13:06

John Dewey

7,1234 gold badges25 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

HMcompfreak · Accepted Answer · 2012-03-13 05:02:14Z

0

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 ..

answered Mar 13, 2012 at 5:02

HMcompfreak

1712 gold badges3 silver badges20 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related