Shutdown instance, copy database files, and re-attach at destination server.

Question

Shutdown instance, copy database files, and re-attach at destination server.

kishoretukuntla

SSC Rookie

Points: 29
More actions
June 18, 2009 at 12:39 am

#133241

Hi All,
I have a requirement like, I am working with two servers,one is in
intranet(lan or local server) and another server(host server) is in internet.I have to save the data from the frontend to these servers(specified databases)at a time, some times net disconnected at that time how can i update the host server when the moment net is
connected.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

kishoretukuntla (6/18/2009)
Hi All,
I have a requirement like, I am working with two servers,one is in
intranet(lan or local server) and another server(host server) is in internet.I have to save the data from the frontend to these servers(specified databases)at a time, some times net disconnected at that time how can i update the host server when the moment net is
connected.

I dont think i understand ur requirement correctly. However if you want updates from the intranet server to go to the internet server, you can shut down the database and reattach the database files to the internet server.

Probably if you tell more on ur requirements, you can get better options.

Pradeep Singh

kishoretukuntla SSC Rookie Points: 29 More actions · Answer 2

hi Thanks for ur reply,

My requirement exactly is, i have a two databases in two different

servers. That servers located one is in my working place(in my office) and another(host server) is at different location.

if internet connection is available that i can do thourgh internet,

but in the case , internet disconnected for some time,

then i have to update the database which is in the host server when

the moment net is connected

kishoretukuntla SSC Rookie Points: 29 More actions · Answer 3

hi Thanks for ur reply,

My requirement exactly is, i have a two databases in two different

servers. That servers located one is in my working place(in my office) and another(host server) is at different location.I have to

update two databases when the request raised from the client

if internet connection is available that i can do thourgh internet,

but in the case , internet disconnected for some time,

then i have to update the database which is in the host server when

the moment net is connected

John H Marsh SSChampion Points: 11671 More actions · Answer 4

Hello,

If you only want to copy data from certain Tables, then may be Replication is what you need.

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

ps. One Orange Chip Points: 29422 More actions · Answer 5

kishoretukuntla (6/18/2009)
hi Thanks for ur reply,
My requirement exactly is, i have a two databases in two different
servers. That servers located one is in my working place(in my office) and another(host server) is at different location.I have to
update two databases when the request raised from the client
if internet connection is available that i can do thourgh internet,
but in the case , internet disconnected for some time,
then i have to update the database which is in the host server when
the moment net is connected

If you want to update one database from another based on the requirement from the client, you can attach/detach files as u mentioned earlier or you can backup one database and restore it to other.

If the target database is over thin connection, you should zip ur backup/database files, the ship it to target location, then perform restore/attach.

Pradeep Singh

ps. One Orange Chip Points: 29422 More actions · Answer 6

John Marsh (6/18/2009)
Hello,
If you only want to copy data from certain Tables, then may be Replication is what you need.
Regards,
John Marsh

Yes, this is a better and faster option. Or you can just drop those tables(with updates) and import new tables from the source requirement(if the request is ad-hoc)

Pradeep Singh