Tag: tip

Miscellaneous

How to Change the Default Backup Directory

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups.  If you don’t change the default location for your installation your default backups location will be “C:Program FilesMicrosoft SQL ServerMSSQL13.MSSQLSERVERMSSQLBackup”  (default location for a SQL Server 2016 installation).   Overtime you might decide you want …

Miscellaneous

Has Your Database Been Backed up in the Last 24 Hours?

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up.  Without recent backups you will not be able to recover your database without potentially losing many days of database updates.  Therefore, you need to make sure on a daily basis that your backups are running …