我自己的项目的sqlserver 2008 r2 express的自动备份的脚本

发布时间：2020-12-12 12:45:08 所属栏目：MsSql教程来源：网络整理

导读：参见上一篇文章 backup_database.bat C: cd C:Program FilesMicrosoft SQL Server100ToolsBinn SQLCMD -S .sqlexpress -U sa -P Dayawan123 ?-i J:Database_Backupbackup.sql backup.sql GO DECLARE ?? @backupTime VARCHAR(20) ? DECLARE ?? @fileN

参见上一篇文章

backup_database.bat

C:
cd C:Program FilesMicrosoft SQL Server100ToolsBinn
SQLCMD -S .sqlexpress -U sa -P Dayawan123 ?-i J:Database_Backupbackup.sql

backup.sql

GO

DECLARE ??
@backupTime VARCHAR(20) ?
DECLARE ??
@fileName VARCHAR(1000) ? ?
SELECT ?
?@backupTime=(CONVERT(VARCHAR(8),GETDATE(),112) +REPLACE(CONVERT(VARCHAR(5),114),':','')) ? ?
SELECT ?
?@fileName='J:Database_BackupDB_'+@backupTime+'.bak' ?
backup database SafetyValve to disk=@fileName ?
GO?

然后是创建的计划任务

safetyValve backup.xml

<?xml version="1.0" encoding="UTF-16"?> <Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task"> ? <RegistrationInfo> ? ? <Date>2015-05-11T16:50:27.0939616</Date> ? ? <Author>WINDOWS-XCBQ5Y7Administrator</Author> ? ? <Description>backup every 2 am</Description> ? </RegistrationInfo> ? <Triggers> ? ? <CalendarTrigger> ? ? ? <StartBoundary>2015-05-11T02:00:00</StartBoundary> ? ? ? <Enabled>true</Enabled> ? ? ? <ScheduleByDay> ? ? ? ? <DaysInterval>1</DaysInterval> ? ? ? </ScheduleByDay> ? ? </CalendarTrigger> ? </Triggers> ? <Principals> ? ? <Principal id="Author"> ? ? ? <UserId>WINDOWS-XCBQ5Y7Administrator</UserId> ? ? ? <LogonType>InteractiveToken</LogonType> ? ? ? <RunLevel>LeastPrivilege</RunLevel> ? ? </Principal> ? </Principals> ? <Settings> ? ? <MultipleInstancesPolicy>IgnoreNew</MultipleInstancesPolicy> ? ? <DisallowStartIfOnBatteries>true</DisallowStartIfOnBatteries> ? ? <StopIfGoingOnBatteries>true</StopIfGoingOnBatteries> ? ? <AllowHardTerminate>true</AllowHardTerminate> ? ? <StartWhenAvailable>false</StartWhenAvailable> ? ? <RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable> ? ? <IdleSettings> ? ? ? <Duration>PT10M</Duration> ? ? ? <WaitTimeout>PT1H</WaitTimeout> ? ? ? <StopOnIdleEnd>true</StopOnIdleEnd> ? ? ? <RestartOnIdle>false</RestartOnIdle> ? ? </IdleSettings> ? ? <AllowStartOnDemand>true</AllowStartOnDemand> ? ? <Enabled>true</Enabled> ? ? <Hidden>false</Hidden> ? ? <RunOnlyIfIdle>false</RunOnlyIfIdle> ? ? <WakeToRun>false</WakeToRun> ? ? <ExecutionTimeLimit>P3D</ExecutionTimeLimit> ? ? <Priority>7</Priority> ? </Settings> ? <Actions Context="Author"> ? ? <Exec> ? ? ? <Command>J:Database_Backupbackup_database.bat</Command> ? ? </Exec> ? </Actions> </Task>

（编辑：李大同）

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