domingo, 28 de octubre de 2012

Changing default database backup folder for SQL Server

If you don't modify the default paths for Data, Logs and Backup's on SQL Server Installation, you can modify it then.

To Modify SQL Data or Log Directory, go to Server Properties, Database Settings, Database Default Locations (marked in red).


But, where can we change SQL Backup directory?

In Windows Registry.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer

This is only an example, probably you must change Instance Name

Backup Directory (See image below).






No hay comentarios:

Publicar un comentario