Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Rollback Rss

   Items 1 to 6 of 6   

Difference between Delete,Truncate and drop

By Vivek Raj 2014/12/01 | Category: transactions
Rating: (not yet rated) |  Discuss |   Briefcase | 2,104 reads

Rollback and Recovery Troubleshooting; Challenges and Strategies

What happens if your database deployment goes awry? Grant Fritchey has some troubleshooting advice to get you out of a bind.  Read more...
By Additional Articles 2014/07/08 | Source: SimpleTalk | Category: rollback
Rating:  Rate this |   Briefcase | 4,421 reads

Steps to rollback database changes without impacting SQL Server Log Shipping

When pushing a major release to a large production database, you want to know that you'll be able to rollback changes if the need arises. These are some simple steps which we can follow to ensure that we don't have to reconfigure log shipping all over again thereby saving time and ensuring systems are not affected when rolling back changes.   Read more...
By Additional Articles 2013/10/23 | Source: | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 3,333 reads

Custom Logging in a transaction

Ever happened that your custom log got rolled back and you were left with nothing but an error_message()? Try to log into a table variable.  Read more...
By Peter Sloboda 2010/07/22 | Source: | Category: custom logging
Rating: |  Discuss |   Briefcase | 1,111 reads

DDL Rollback

By Hari Sharma 2009/10/05 | Category: rollback
Rating: (not yet rated) |  Discuss |   Briefcase | 3,926 reads

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I

Using an audit table to rollback changes to data might be a nice addition to many applications. David McKinney's new series looks at how you can use this data for RollBack or RollForward.  Read more...
By David McKinney 2009/05/11 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 6,020 reads
   Items 1 to 6 of 6   
transactions (2)    
t-sql (2)    
auditing (1)    
custom logging (1)    
ddl (1)    
delete (1)    
log shipping (1)    
recover database (1)    
troubleshooting (1)    
truncate (1)