mssql server backup script

mssql server backup script

net stop w3svc

sqlcmd -S .\sqlexpress -E -Q "alter database fb1 set offline"
sqlcmd -S .\sqlexpress -E -Q "alter database fb2 set offline"
sqlcmd -S .\sqlexpress -E -Q "alter database fb3 set offline"
sqlcmd -S .\sqlexpress -E -Q "alter database fb4 set offline"
sqlcmd -S .\sqlexpress -E -Q "alter database fb5 set offline"
sqlcmd -S .\sqlexpress -E -Q "alter database fb6 set offline"

For /F "Tokens=2" %%I in ('Date /T') Do Set datum=%%I
For /F "Tokens=1,2 delims=:" %%I in ('Time /T') Do Set vrijeme=%%I.%%J

c:\progra~1\winrar\rar.exe a C:\user1\baza\BACKUP\KAND_%datum%_%vrijeme%.rar c:\user1\baza\fb1.*
c:\progra~1\winrar\rar.exe a C:\user1\baza\BACKUP\VELE_%datum%_%vrijeme%.rar c:\user1\baza\fb2.*
c:\progra~1\winrar\rar.exe a C:\user1\baza\BACKUP\NEKR_%datum%_%vrijeme%.rar c:\user1\baza\fb3.*
c:\progra~1\winrar\rar.exe a C:\user1\baza\BACKUP\USRS_%datum%_%vrijeme%.rar c:\user1\baza\fb4.*
c:\progra~1\winrar\rar.exe a C:\user1\baza\BACKUP\RALE_%datum%_%vrijeme%.rar C:\user1\baza\fb5.*
c:\progra~1\winrar\rar.exe a C:\user1\baza\BACKUP\BAJZ_%datum%_%vrijeme%.rar C:\user1\baza\fb6.*

sqlcmd -S .\sqlexpress -E -Q "EXEC sp_trace_setstatus 1, 0"
sqlcmd -S .\sqlexpress -E -Q "EXEC sp_trace_setstatus 1, 2"
sqlcmd -S .\sqlexpress -E -Q "EXEC fb1.dbo.start_trace"

sqlcmd -S .\sqlexpress -E -Q "alter database fb1 set online"
sqlcmd -S .\sqlexpress -E -Q "alter database fb2 set online"
sqlcmd -S .\sqlexpress -E -Q "alter database fb3 set online"
sqlcmd -S .\sqlexpress -E -Q "alter database fb4 set online"
sqlcmd -S .\sqlexpress -E -Q "alter database fb5 set online"
sqlcmd -S .\sqlexpress -E -Q "alter database fb6 set online"

net start w3svc