You can check my other post BACKUP STATUS to know the current DB backup status.
exec sp_msforeachdb '
use [?];
IF ''?'' not in (
''master'',''tempdb'',''model'',''msdb'',''DBAdmin'')
BEGIN
use [master]
Print ''?''
ALTER DATABASE [?] SET
READ_ONLY WITH ROLLBACK IMMEDIATE
Print ''Marked --
READ_ONLY''
BACKUP DATABASE [?]
to disk = ''<Disk
Location/Path>\?_Backup_FULL_20190924.bak''
with COMPRESSION
Print ''Backup Done''
ALTER DATABASE [?] SET
MULTI_USER WITH NO_WAIT
END
ELSE
BEGIN
Print DB_NAME()+ '' --
IGNORED''
END'
|
Thanks.
g392h6oeeba475 vibrating dildos,sex toys,dildos,love dolls,wolf dildo,women sex toys,double dildos,horse dildo,Panty Vibrators o261t3rikfs707
ReplyDelete