Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Hello experts !
 
I want to automate the process of taking incremetal backup from server 1 in the directory of server 2 and restore every lastest differential backup in the directory to server 2 existing db having same names in both servers...
 
Iam using sqlserver2008 r2.
 
Your help really ease my life.
 

Thank you
farh
Posted 15-Dec-12 22:48pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Sir,
 
I find the link to restore differntial backup but having error.My level is very low the above link very informative bu iam unable to implement?
 

 
http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/[^]
 
I commented all the all other full backup and transaction logs leaved differential but having error back
 
<db2Msg 16916, Level 16, State 1, Line 42
A cursor with the name 'backupFiles' does not exist.
Msg 16916, Level 16, State 1, Line 61
A cursor with the name 'backupFiles' does not exist.
Msg 16916, Level 16, State 1, Line 71
A cursor with the name 'backupFiles' does not exist.
Msg 16916, Level 16, State 1, Line 72
A cursor with the name 'backupFiles' does not exist.
RESTORE DATABASE db2 WITH RECOVERY>
 

help me out ...
thanks
  Permalink  
v2
Comments
Nelek at 17-Dec-12 18:35pm
   
Please don't post solutions to add information, to ask something or to comment another user.
- To add information to your message, you can use the widget "Improve question" / "Improve solution" at the bottom of your text.
- To ask/answer a user, you can use the widget "Have a question or comment?" (as I am doing right now with you) or the widget "reply" in another comment.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Dnyaneshwar@Pune 719
1 CHill60 240
2 Sergey Alexandrovich Kryukov 220
3 TheRealSteveJudge 220
4 CPallini 200
0 Sergey Alexandrovich Kryukov 9,078
1 OriginalGriff 6,771
2 Peter Leow 4,282
3 Zoltán Zörgő 3,809
4 Richard MacCutchan 2,661


Advertise | Privacy | Mobile
Web02 | 2.8.150128.1 | Last Updated 17 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100