Link to home
Start Free TrialLog in
Avatar of joe_echavarria
joe_echavarriaFlag for Dominican Republic

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,
Avatar of PadawanDBA
PadawanDBA

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/library/ms345408.aspx#Examples
Avatar of joe_echavarria

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 ?
ASKER CERTIFIED SOLUTION
Avatar of PadawanDBA
PadawanDBA

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial