SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Harsha Bhagat

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Transactional Logs Restore

Testing Transaction Logs restore  Read more...
By Harsha Bhagat 2018/07/09 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 232 reads

Delete Change Tracking table data sys.syscommittab

With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 210 reads

Delete Files in Shared Location/SAN

Delete files via TSQL procedure in shared location  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 389 reads

Restore Redgate Transaction logs files via SQL

The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 263 reads
   Items 1 to 4 of 4