Hi All,
There are 2 database residing in one single server
currently.

We are planing to take up this 2 database to different
server in same network.

Please give me suggestion on various possible ways to do
this. Is that MS.Link Server is the only option?

Thanks in Advance,
Sachi

Hi Sachi

This is quite complex. I suggest you read Books Online,
use Index tab and put in Copying Databases and then select
Overview.

Hope this helps,

Tim

This depends on your local demands, and Database sizes.

Options I would look into

Full Backup and Restore, this is one of the best ways, however it can be
time consuming, but backups can be run to the new machine and can

a.) run a full backup
b.) Restore the full backup to the new server
c.) wait for a window of down time, then disable access to the DB
d.) take a differential backup and restore it to the full restore you
completed earlier

This would limit your down time to the duration of the differential backup
and it's restore, look in Books Online at Backup and Restore

Deataching then re-attaching the Databases once you have copied the
Database Files to the new server is very viable, but may be time consuming
when you copy the files over, check out Books on line sp_attach_db and
sp_detach_db

Whatever you do you want to make 100% sure you have a full backup of the
Data prior to implimenting something like this.

Hope this helps

Hi Sachi,
This is a bold move when most companies in the world are looking at
consolidating SQL Servers into one system, due to the licensing issues MS
has changed. What type of reasoning is behind the move? Disaster recovery,
performance, redundancy?. All of these can be handled without splitting
DB's

--
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.asp. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.asp. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.asp. Free icon extraction
program
http://www.ag-software.com. Free programming tools

"Sachi" <sachiek_sachiek (AT) hotmail (DOT) com> wrote