sql server数据库备份语句
时间:2021-07-01 10:21:17
帮助过:64人阅读
set @strPath = convert(NVARCHAR(19),getdate(),120)set @strPath = REPLACE(@strPath, ‘:‘ , ‘.‘)set @strPath = ‘备份路径‘+‘CopyBSS‘+@strPath + ‘.bak‘backup database 数据库名 to disk = @strPath with noinit , nounload , noskip , STATS = 10, NOFORMATsql server数据库备份语句
标签:sql server数据库备份语句