sqlserver备份和恢复-5

视图备份和恢复

备份

1.

2.

恢复

1.

2.

3.

?

bat备份恢复

原文:

https://www.cnblogs.com/lonelyxmas/p/7958649.html

备份：

sqlserverbackup.bat
--------------------------------------
@echo off
set path=%path%;D:Program FilesMicrosoft SQL Server100ToolsBinn
set BakDir=‘D:backupsqlserver‘
echo backup start
osql.exe -S 127.0.0.1 -U sa -P xxxxxx -i Test_ReportV3backup.sql -o D:backupsqlserverTest_ReportV3backup.out
osql.exe -S 127.0.0.1 -U sa -P xxxxxx -i West_Report(Bata)backup.sql -o D:backupsqlserverWest_Report(Bata)backup.out
osql.exe -S 127.0.0.1 -U sa -P xxxxxx -i West_TestReportbackup.sql -o D:backupsqlserverWest_TestReportbackup.out
forfiles /p %BakDir% /s /m *.* /d -10 /c "cmd /c del @file"
echo backup end
---------------------------------------

*.sql
---------------------------------------
DECLARE @name varchar(50)
DECLARE @datetime char(14)
DECLARE @path varchar(255)
DECLARE @bakfile varchar(255)

set @datetime=CONVERT(char(8),getdate(),112) + REPLACE(CONVERT(char(8),108),‘:‘,‘‘)
set @path=‘D:backupsqlserver‘
set @name=‘Test_ReportV3‘
set @[email?protected]+‘‘[email?protected]+‘_‘+‘bak_‘[email?protected]+‘.BAK‘
backup database @name to disk[email?protected] with name=@name
go
---------------------------------------

?恢复

请看原文

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!