Occasionally I make little notes, fun SQL facts, for myself about things I recently learned about SQL Server. Here are the most recent, mostly restore related.
- A stored procedure cannot be created if it references a database in the middle of a restore
- A database cannot be restored to point in time by using two full backups right after one another (sad). –Side note: The differentials could not be used and the transaction log complained about being later in the LSN chain that I expected it to be.
- Service accounts and application accounts tend to reconnect to the database after running Kill Users script if the DBA doesn’t act fast enough to switch the DB over to Single User (and take advantage of that switch) or Restore the database (etc)
- The link between a Full backup and its Differentials is called a Differential Base, not a backup chain
- A database restored WITH STANDBY cannot have Differential backups restored to it. Only Transaction Log Backups. (also sad. Why won’t SQL do what I want it to do on those rare instances where I need it to not do what it was programmed to do?)
- A transaction log backup can be restored in the GUI via the Tasks->Restore->Database choice (if that’s the option clicked instead of the Transaction Log choice)
- Backup files can be deleted in the middle of a restore (just happened to me yesterday when I was 80% done. GAH!)
Yeah. Those are my fun SQL facts of the week. Which ones do you have?
