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.
| Author |
Topic |
|
bhayyu
Starting Member
3 Posts |
 Posted - 2010-01-13 : 04:05:11
|
Plz Help Me My DBA takes increamental database daily in 3 pm.now my problem is how i 'll be restore increamental database in remote location.i m used SQL 2005.Please give me any solution as soon a posible..... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 04:10:05
|
| then you need to restore last full backup and then apply each incremental backups in sequence until recent one |
 |
|
|
bhayyu
Starting Member
3 Posts |
Posted - 2010-01-13 : 05:13:07
|
| thanks visakh16!!!bt i know it .my main problem is how i connect two remote servers (placed two diffrent states of india).den i want to restore increamental backup in both servers.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 05:46:55
|
quote:
Originally posted by bhayyu
thanks visakh16!!!bt i know it .my main problem is how i connect two remote servers (placed two diffrent states of india).den i want to restore increamental backup in both servers....
then you need to specify server path using UNC path like belowhttp://support.microsoft.com/?kbid=555128 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-13 : 08:26:18
|
Or just copy the files from ServerA to ServerB somehow (via network, CD, DVD, memory stick, stealing the hard drive from ServerA  ) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 08:36:35
|
quote:
Originally posted by Kristen
Or just copy the files from ServerA to ServerB somehow (via network, CD, DVD, memory stick, stealing the hard drive from ServerA )
That was a good one |
|
|
|
bhayyu
Starting Member
3 Posts |
Posted - 2010-01-18 : 01:24:43
|
i have not got any solution. plz solve my problem.how i updated my sql database in remote server at the time of my local serever. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-01-18 : 04:07:33
|
| More details on what you're trying to do here?If you want two servers in sync, consider replication.If you want a copy of the first, backup/restore (as Visakh and Kristen discussed) will workIf you want something else, explain what it is that you want.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Restore increamental database in remote location