Thursday, February 16, 2012

backup/restore

hi,
I want to know if there is a way - other than backup and restore database (because restore takes too much time as the DB size grows) - to transfer all the data from one database on the server to another on a local SQLServer. it has to be done daily, so that the manager will always have an updated copy of the data on his machine.

Any help?
Thanks in advance

you can configure replication / log shipping / database mirroing etc. but it will impact the production server performance and it nees to be monitored/administered constantly

Madhu

No comments:

Post a Comment