my code stock.com

tei219

do_mirroring_database_dbcc_shrink
by tei219

Snippet options

Download: Download snippet as do_mirroring_database_dbcc_shrink.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

exec sp_MSforeachdb @command1 = '
	if ''?'' in (select db_name(database_id) from master.sys.database_mirroring where mirroring_state = 4  and mirroring_role = 1)
	begin
		use ?
		checkpoint
		backup log [?] to disk = ''NUL'' with noformat, init, name = N''? backup'', skip, norewind, nounload
		dbcc shrinkfile(2,100)
	end
'

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.