how to copy database from one server to other? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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 2005 Forums

SQL Server Administration (2005)

how to copy database from one server to other?

Author

Topic

hirani_prashant
Yak Posting Veteran

93 Posts

Posted - 2008-08-11 : 04:44:17

Hello All,

I Want to copy database from one server to other server daily at 6:00 PM.

how can one perform this??

-- thanks
Prashant

hitesh6221
Starting Member

28 Posts

Posted - 2008-08-11 : 05:04:19

You can use database copy tool

select database -> Task -> Copy Database
click next and select source server Enter UserName and Password and then select destination server enter UserName and Password

Then user server select "Use SQL Mgmt object method"
click Next and select Database to copy Not move
Then Click Next and Give DB name and Then click next to set log file
Now Most importent step for you schedule Here you set 6.00 PM Daily
Then click Next and finish

Regards,
Hitesh Soni

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-11 : 08:58:06

Backup database and copy file to destination server and restore it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources