joe_echavarria
asked on
Configure temp and backups default directory location in sql server 2008
Hi,
I have already installed MS SQL Server 2008 and did not set the default directory location for the temp and backup paths.
The installation is done now and i want to set the temp directory default and the backup directory default ( for full and trans).
How do i set it up ?
Thanks,
I have already installed MS SQL Server 2008 and did not set the default directory location for the temp and backup paths.
The installation is done now and i want to set the temp directory default and the backup directory default ( for full and trans).
How do i set it up ?
Thanks,
After you connect to the instance, you can right click the instance name > properties > database settings > Database default locations > Backup. Just change the default location for the backups there. In order to move the TempDB, you'll just want to follow the steps here: https://msdn.microsoft.com /en-us/lib rary/ms345 408.aspx#E xamples
ASKER
@PadawanDBA
I have changed the TempDB settings after following the steps at msdn.
But when i look at instance name > properties > database settings > Database default locations , i can not find Backup. I just find Data and Log directories.
Where to set the Backup Location ?
I have changed the TempDB settings after following the steps at msdn.
But when i look at instance name > properties > database settings > Database default locations , i can not find Backup. I just find Data and Log directories.
Where to set the Backup Location ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.