Backing up SQL server - no folder content

[stla]

Good day,

Can anyone see what I have done wrong with my script; I would like to back up the contents SQL however only the folder structures are being copied, ther are no files!

Best regards

-------------------------------------------------
rem

net stop MSSQL$SBSMONITORING
net stop MSSQL$SHAREPOINT
net stop MSSQL$WSUS

set quelle1="C:\Programme\Microsoft SQL Server"
set ziel1="G:\Raid\SQL_Datensicherung"

robocopy %quelle1% %ziel1% /E /purge /COPYALL /V /NP /Xo /R:2 /W:2

 

[mrdenny]

Don't copy the data files. Use the BACKUP DATABASE command to backup each database to a backup file so that you don't have to take the SQL Services offline while you do the backups.

Some backup and recovery information can be found here.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog