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.

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

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

According to Idera, its SQL Server database backup and recovery solution, SQL safe, helps database administrators increase backup compression up to 95% and is at least 50% faster than native SQL ...

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

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.