Andy Leonard returns with part 2 on the basics of the File System Task in SSIS, useful whenever your data moves to and from flat files.
SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups
A DBA asked whether backups on new EMC storage should use a 256 KB transfer size. Here is what I learned about the MaxTransferSize parameter.
SQL SERVER – Backup and Restore Behavior of ReadOnly Filegroup Databases
How do backups behave for a database with a ReadOnly filegroup, and does a restore keep that setting? I walk through it with simple T-SQL scripts.
SQL SERVER – ReadOnly Databases with ReadOnly File Attribute
A reader attached a database that came up ReadOnly and would not switch to ReadWrite. Here is how the ReadOnly file attribute causes it, with repro steps.
SQL SERVER – Database Stuck in “In Recovery” Mode After Restart
Is your database stuck In Recovery after a SQL Server restart? I explain the analysis, roll forward and rollback phases and what you can do meanwhile.
SQL SERVER – ReadOnly Databases and Notes Using Snapshots
Can you get the ReadOnly error without marking the database ReadOnly? Yes, using snapshots. Here is a script that shows the behavior step by step.
Building the Restore Script for the Latest Backup Chain From msdb
Do not type a restore sequence by hand at 2 AM. Let msdb tell you the order, and prove the script works before you need it.