数据库备份 [英] Database back up
本文介绍了数据库备份的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
如何使用sqlcmd排除数据库备份？
sqlcmd -E -S $（ESCAPE_SQUOTE （SRVR）） - d master -Q" EXECUTE [dbo]。[DatabaseBackup] @Databases ='USER_DATABASES'，@ Memory = N'\\ somewhere'， @BackupType ='FULL'，@ Verify = 'Y'，@ CleanupTime = 360，@ CheckSum ='Y'，@ LOGToTable ='Y'" -b
解决方案
带减号，示例 -
sqlcmd -E -S
（ESCAPE_SQUOTE（SRVR）） - d master -Q" EXECUTE [dbo]。[DatabaseBackup] @Databases ='USER_DATABASES，-EDDSResource'，@ Memory = N'\\somewhere' ，@ BackupType ='FULL'，@ Verify ='N'，@ NumberOfFiles = 2，@ CleanupTime = 672，@ CheckSum ='Y'，@ LogToTable ='Y'" -b
How do you exclude a database from being backed up using the sqlcmd?
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE [dbo].[DatabaseBackup] @Databases = 'USER_DATABASES', @Directory = N'\\somewhere', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 360, @CheckSum = 'Y', @LogToTable = 'Y'" -b
解决方案
With a minus sign, Example -sqlcmd -E -S
(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE [dbo].[DatabaseBackup] @Databases = 'USER_DATABASES,-EDDSResource', @Directory = N'\\somewhere', @BackupType = 'FULL', @Verify = 'N', @NumberOfFiles = 2, @CleanupTime = 672, @CheckSum = 'Y', @LogToTable = 'Y'" -b
这篇关于数据库备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
