Just inherited a new SQL 2000 DB -- the nitely FULL Backup job has an imbedded step which references a server & directory called (see entire script at end of this note):
\\CustDB\SQLBackups\FULL\Full_ApplData_01of04.bak'
\\CustDB\SQLBackups\FULL\Full_ApplData_02of04.bak'
\\CustDB\SQLBackups\FULL\Full_ApplData_03of04.bak'
\\CustDB\SQLBackups\FULL\Full_ApplData_04of04.bak'
When I log on to this SQL Server I do not see the directory called SQLBackups\FULL..... I do see the actual backup files in a directory called:
\\CustDB\Program Files\Microsoft SQL Server\MSSQL\backup\FULL
How is this configured? (Usually I'll see the directory name in Windows Explorer)
SCRIPT (imbedded as a job step):
Declare @str1 as nvarchar(100),@str2 as nvarchar(100),@str3 as nvarchar(100),@str4 as nvarchar(100)
Set str1='\\CustDB\SQLBackups\FULL\Full_ApplData_01of04.bak'
Set str2='\\CustDB\SQLBackups\FULL\Full_ApplData_02of04.bak'
Set str3='\\CustDB\SQLBackups\FULL\Full_ApplData_03of04.bak'
Set str4='\\CustDB\SQLBackups\FULL\Full_ApplData_04of04.bak'
Backup database Appl_Data
to disk=@str1, disk=@str2, disk=@str3, disk=@str4
with init, noformat
\\CustDB\SQLBackups\FULL\Full_ApplData_01of04.bak'
\\CustDB\SQLBackups\FULL\Full_ApplData_02of04.bak'
\\CustDB\SQLBackups\FULL\Full_ApplData_03of04.bak'
\\CustDB\SQLBackups\FULL\Full_ApplData_04of04.bak'
When I log on to this SQL Server I do not see the directory called SQLBackups\FULL..... I do see the actual backup files in a directory called:
\\CustDB\Program Files\Microsoft SQL Server\MSSQL\backup\FULL
How is this configured? (Usually I'll see the directory name in Windows Explorer)
SCRIPT (imbedded as a job step):
Declare @str1 as nvarchar(100),@str2 as nvarchar(100),@str3 as nvarchar(100),@str4 as nvarchar(100)
Set str1='\\CustDB\SQLBackups\FULL\Full_ApplData_01of04.bak'
Set str2='\\CustDB\SQLBackups\FULL\Full_ApplData_02of04.bak'
Set str3='\\CustDB\SQLBackups\FULL\Full_ApplData_03of04.bak'
Set str4='\\CustDB\SQLBackups\FULL\Full_ApplData_04of04.bak'
Backup database Appl_Data
to disk=@str1, disk=@str2, disk=@str3, disk=@str4
with init, noformat