Displaying posts categorized under

Uncategorized

Backup and Restore FileGroup

Step1. Create a db with two file groups Step2. Create two tables, one on each FG Step3. Insert a row into each table Step4. Backup FG 1 Step5. Restore as a new DB Step6. One table should be accessible. Other should be down

SSIS Package to Backup Jobs, Operators and Alerts Script using SMO

SSIS Package to Backup Jobs Script using SMO. This package willl use some SMO reference and generates SQL Server Jobs, Operators and Alerts script backup. I had written the code for SQL Server Jobs only and commented code for Operators backup and Alerts Backup. You just need to replcace Operators or Alerts instead of Jobs. [...]