本文介绍了数据库备份的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何使用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

解决方案


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

解决方案



这篇关于数据库备份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-13 23:12