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.

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 ...

AWS released an update to its Relational Database Service (RDS) that allows users to take advantage of native SQL Server backup and restore functionality. AWS beat Microsoft Azure to market with ...

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 have my SQL Server 2000 maintenance plan for my databases set to delete any transaction log backups older than 5 days. For most of my databases this is working, but for 2 databases this isn't ...

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.