In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Joey on SQL Server The Right Approach to Database Backups Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process.

For backups of Microsoft SQL Server databases, DBAs would be well served to turn to Imceda Software’s LiteSpeed 2005.

Similar to LiteSpeed, SQLsafe improves on native SQL Server backups with compression, encryption, faster backups and restores, and lots of extras that make managing database backups easier.

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Ohan Oda discusses making the Lens in Maps AR ...

Backing up SQL Server is a standard practice, but knowing which recovery model to use can be confusing. Use these tips to get started with your backup strategy.

Our server group wants to take over our SQL Server 05 backups for some reason. (Not sure why, our backups and restores work fine, so who knows why they want the change)Anyway, came into work and ...

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...