Click here to Skip to main content
15,914,820 members
Home / Discussions / Database
   

Database

 
QuestionHow do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
BobClarkSQL22-Jan-09 3:15
BobClarkSQL22-Jan-09 3:15 
AnswerRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. [modified] Pin
Wendelius22-Jan-09 3:27
mentorWendelius22-Jan-09 3:27 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
BobClarkSQL22-Jan-09 4:00
BobClarkSQL22-Jan-09 4:00 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
Wendelius22-Jan-09 4:08
mentorWendelius22-Jan-09 4:08 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
BobClarkSQL22-Jan-09 4:19
BobClarkSQL22-Jan-09 4:19 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
Wendelius22-Jan-09 4:35
mentorWendelius22-Jan-09 4:35 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
BobClarkSQL22-Jan-09 4:40
BobClarkSQL22-Jan-09 4:40 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
BobClarkSQL22-Jan-09 4:52
BobClarkSQL22-Jan-09 4:52 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
Wendelius22-Jan-09 5:06
mentorWendelius22-Jan-09 5:06 
GeneralRe: How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes in the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. Pin
BobClarkSQL22-Jan-09 5:42
BobClarkSQL22-Jan-09 5:42 
QuestionInsert query and Cursor in same stored procedure Pin
Jay Royall21-Jan-09 23:28
Jay Royall21-Jan-09 23:28 
AnswerRe: Insert query and Cursor in same stored procedure Pin
Wendelius21-Jan-09 23:33
mentorWendelius21-Jan-09 23:33 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Jay Royall21-Jan-09 23:49
Jay Royall21-Jan-09 23:49 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Wendelius22-Jan-09 0:00
mentorWendelius22-Jan-09 0:00 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Jay Royall22-Jan-09 0:05
Jay Royall22-Jan-09 0:05 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Wendelius22-Jan-09 0:13
mentorWendelius22-Jan-09 0:13 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Jay Royall22-Jan-09 0:21
Jay Royall22-Jan-09 0:21 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Wendelius22-Jan-09 0:29
mentorWendelius22-Jan-09 0:29 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Ennis Ray Lynch, Jr.22-Jan-09 6:23
Ennis Ray Lynch, Jr.22-Jan-09 6:23 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Jay Royall22-Jan-09 6:31
Jay Royall22-Jan-09 6:31 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Ennis Ray Lynch, Jr.22-Jan-09 6:36
Ennis Ray Lynch, Jr.22-Jan-09 6:36 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Jay Royall22-Jan-09 9:38
Jay Royall22-Jan-09 9:38 
Thanks for your response. I understand your concern about cursors but unfortunately I don't think your idea is going to work. The reason is because the insert statement is inserting a record with a sequence which isn't a multiple of 10, i.e. 15, 25, 35 etc. This then means that the newly inserted record is in the right place accoring to sequence number. The cursor then gets all the records ordered by sequence, and updates them back to numbers divisible by 10, including the newly inserted record (obviously, the sequence doesn't have to be multiples of 10, it could of easily have been 2, but still).

Again, I realise that cursors are not a good idea but I don't see any other way around it (other than doing it from my VB.NET application with multiple database calls which definately isn't a good idea). Also, there are going to be at most 30 records in this table so I thought that using a cursor wouldn't be too much of a problem.

Like I said, I am fairly new to this so any other suggestions you may have are welcomed.
GeneralRe: Insert query and Cursor in same stored procedure Pin
Ennis Ray Lynch, Jr.22-Jan-09 9:46
Ennis Ray Lynch, Jr.22-Jan-09 9:46 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Jay Royall22-Jan-09 9:52
Jay Royall22-Jan-09 9:52 
GeneralRe: Insert query and Cursor in same stored procedure Pin
Wendelius22-Jan-09 9:50
mentorWendelius22-Jan-09 9:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.