Hi,
I had SQL Server 2000 installed like below:
Installation Directory = C:\Program Files\Microsoft SQL Server
Default data directory = D:\
Default log directory = D:\
I found out that the data is stored in D:\Program Files\Microsoft SQL Server\MSSQL\data and backup is done in D:\Program Files\Microsoft SQL Server\MSSQL\backup
However, Microsoft says we should never put the ..\backup and ..\data folders in the same partition.
My question is: How can I move the path of the backup directory?
I checked the registy but this is what I found:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
..BackupDirectory=C:\Program Files\Microsoft SQL Server\MSSQL\backup (<-- note it is pointing to C:\ not D:\)
..DefaultData=D:\
Can somebody help please?
http://search.msn.com/results.aspx?q=Introduction+to+Microsoft+SQL+Server%e2%84%a2+2000+Reporting+Services
Beneficial or non-beneficial link above
http://support.microsoft.com/kb/185663/
|||Hi,
As you reach to the correct part change the values of .BackupDirectory=<pathyouwanttoSoreBackUp>
or/and if you are using Schedule/Maintanance Plan you may specify the path their too.
Hemantgiri S. Goswami
