Backup database in CMS
Sometime you know the database name which you want to backup, but you don't know which server it is on....
2012-05-09
1,120 reads
Generate restore script automatically by backup history table
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
6,990 reads
Setup database mirroring and log shipping together
SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...
2012-04-25 (first published: 2012-04-21)
12,421 reads
script system object in resource database
When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...
2012-04-19
1,035 reads
Log shipping setup problem
Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping....
2012-04-18
2,633 reads
Why I can not connect sql server ???
Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...
2012-04-10
6,420 reads
Why shrink sql server data file failed?
Today I need to shrink a big data file, I know shrink file is not a best practise, and it...
2012-04-07
2,402 reads
Clean SQL Server Cache
I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet...
2012-04-06
26,812 reads
SQL Server 2012 license
Not sure if it is a good news or bad news, SQL Server 2012 license shifts from processor-based to core-based.......here...
2012-04-05
1,946 reads
Install SQL Server 2012 Book online on local disk
After installing the SQL Server 2012 on my laptop, I found there is only online document available, no local book...
2012-04-01
25,998 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers