Tags » Microsoft SQL Server

What's in my backup file?

Restoring a backup file is pretty easy right?

RESTORE DATABASE  FROM DISK = 'C:\backups\backup.bak';

Ok, but what if more than one database backup is stored in that single backup file? 566 more words

SQLServerPedia Syndication

London BI/SQL Server user groups.

If you are BI based and want to meetup with other in London, whether technical or business based here as some contacts.

https://sqlserverfaq.com/ – General sql server (covers lots of usergroups) 60 more words

Microsoft SQL Server

SQL server database mirroring and practical demonstration.

SQL Server database mirroring is a disaster recovery and high availability technique that involves two or more SQL Server instances on the same or different machines. 1,118 more words

Microsoft SQL Server

Shrinking Database Files – Let’s Not And Say We Did

— by Lori Brown  @SQLSupahStah

I recently ran into someone who swears that shrinking database files on a production server is a good thing and proudly said they did it on all systems they work on.  443 more words

SQL Server

Deadlock on ALTER DATABASE

I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you ask? Well, 4-5 system sessions were holding locks on the database (and blocking each other). 463 more words

SQLServerPedia Syndication