@echo off
echo -- Архивирование базы данных
osql -S SDATA -E -i Move.backup.sql -n
echo -- Перенос данных
copy \\SDATA\Data\MSSQL\BACKUP\QBill.move.bak \\SWEB\D$\MSSQL\QBill.move.bak
echo -- Восстановление базы данных
osql -S SWEB -E -i Move.restore.sql -nBACKUP LOG [General] WITH NO_LOG
GO
--
DBCC SHRINKDATABASE ([General])
GO
--
BACKUP DATABASE [General]
TO DISK = 'D:\MSSQL\BACKUP\QBill.move.bak'
WITH INIT, NOUNLOAD, NAME = 'General home backup', NOSKIP, STATS = 5, NOFORMAT
GORESTORE DATABASE [General]
FROM DISK = 'D:\MSSQL\QBill.move.bak' WITH FILE = 1, NOUNLOAD, STATS = 5, REPLACE,
MOVE 'General_Log' TO 'D:\MSSQL\General.log',
MOVE 'General_Data' TO 'D:\MSSQL\General.mdf',
MOVE 'General_Event' TO 'D:\MSSQL\General.ndf'
