Daily Archives: 10/01/2014

---

How to get exclusive access for restoring the SQL Server databases?

This entry was posted in Sql Server DBA Sql Server tutorials and tagged access alter backup database restore server sql on 10/01/2014 by Blog Admin.

Scenario proposal A task that you may be faced with as a DBA is the need to refresh a test or development database on a periodic basis.  This may be a scheduled process or it may be an ad hoc process.  One of the things that you need to do when restoring a database is […]

---

How to change the Sql Server backup folder?

This entry was posted in Sql Server DBA Sql Server tutorials and tagged backup sqlserver2005 sqlserver2008 on 10/01/2014 by Blog Admin.

Scenario proposal When you install SQL Server the path for the installation is generally something such as the following: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQL.  In this directory there are also folders for your DATA files and also your BACKUP files.  Within SQL Server Management Studio you have the ability to change the default location for your […]

---