copy database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

copy database

Author

Topic

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-10 : 08:39:55

Hi

In SERVER 'server01' DATABASE 'MARK_PRO' IS THERE. I want to copy this database 'MARK_PRO' to SERVER 'server02'
how cal i do it

please suggest me iam in critical situation

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-10 : 08:42:30

The easiest way is to backup the database on Server01 and restore the backup to Server02.

Peter Larsson
Helsingborg, Sweden

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-10 : 08:46:14

i tried this but it is giving
error

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-10 : 08:48:38

What are you going to do about that?
I can't read minds (yet), so you will have to post the error message you are getting.

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-10 : 09:03:25

The more complicated ways are:

1. Script all database objects, run script on destination server, copy data using BCP or DTS
2. Create destination database and use DTS to create objects and copy data.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-10 : 09:30:00

device activation error
the physical filename 'd:\mssql\pidbqa_data.mdf may be incorrect.
file pidbqa_data cannot be restored to d:\ mssql\pidba_data.mdf use WITH MOVE to identify avalid location
device activation error
the physical filename 'd:\mssql\pidbqa_log.ndf may be incorrect.
file pidbqa_data cannot be restored to d:\ mssql\pidba_log.ndf use WITH MOVE to identify avalid location

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-10 : 09:57:05

Do you have the same path on the destination server?
Try to restore and change path on the destionation server. Do NOT change logical names, just paths and filename for the database.

Peter Larsson
Helsingborg, Sweden

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-10 : 12:32:54

And make sure you use a path name that exists - if you use a path to a folder that does not exist, you'll just get an error, SQL Server will not create the folder for you or prompt you to create it.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-10 : 13:17:23

quote:
Originally posted by putane.sanjay

device activation error
the physical filename 'd:\mssql\pidbqa_data.mdf may be incorrect.
file pidbqa_data cannot be restored to d:\ mssql\pidba_data.mdf use WITH MOVE to identify avalid location
device activation error
the physical filename 'd:\mssql\pidbqa_log.ndf may be incorrect.
file pidbqa_data cannot be restored to d:\ mssql\pidba_log.ndf use WITH MOVE to identify avalid location

So, what happened when you tried the instructions in the error message that said to "use WITH MOVE to identify a valid location" ?

CODO ERGO SUM

Kristen
Test

22859 Posts

Posted - 2007-01-10 : 15:52:16

For an example of Restore Syntax see:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-11 : 01:44:21

successfully copied the database

THANK U FOR NICE SUGGESTIONS
SANJAY PM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources