175 reputation
17
bio website
location Switzerland
age 37
visits member for 3 years, 7 months
seen Jul 31 at 6:40

If you like StackOverflow favorites and wish improvements read my meta post and vote up.


Feb
5
accepted Rebuild the Fulltextcatalog
Feb
5
asked Rebuild the Fulltextcatalog
Aug
9
awarded  Popular Question
May
21
awarded  Caucus
May
21
awarded  Constituent
Apr
7
accepted When do I need to backup the Service Master Key?
Jul
23
comment When do I need to backup the Service Master Key?
@RemusRusanu It's documented here technet.microsoft.com/en-us/library/aa337561 I just don't see the point of do a backup of it as it's not needed to restore a encrypted databse. I was just wondering if there are some scenarios where it might be needed as i can't find any. thanks.
Jul
20
comment When do I need to backup the Service Master Key?
Yes that's clear. My question is more why is there a need (or for what purpose) to backup the Service master key. See technet.microsoft.com/en-us/library/aa337561
Jul
20
comment When do I need to backup the Service Master Key?
Yes I did. I needed the certificate and the key to restore it on Server B. (I did a backup of the Certificate and Key). However on B I created a new Master Key (not restored the one from Server A) and was able to Restore my database.
Jul
20
revised When do I need to backup the Service Master Key?
edited body
Jul
20
asked When do I need to backup the Service Master Key?
Sep
12
awarded  Editor
Sep
12
revised Why are my SQL Server 2008R2 databases not mirroring?
added 2 to the 2008R
Sep
12
suggested suggested edit on Why are my SQL Server 2008R2 databases not mirroring?
Aug
2
comment Role db_ddladmin not working properly on SQL Server 2008
Hmm no. It helped me to find the solution, but his answer is not correct to solve my problem. So the downvote on my post is in my opinion wrong ;-)
Aug
2
accepted Role db_ddladmin not working properly on SQL Server 2008
Aug
2
answered Role db_ddladmin not working properly on SQL Server 2008
Aug
2
comment Role db_ddladmin not working properly on SQL Server 2008
It's also not working with SQLServer 2008 R2.
Jul
27
comment Role db_ddladmin not working properly on SQL Server 2008
can't believe there is no fix for SQL Server 2008. really annoying. thanks for your help.
Jul
26
awarded  Scholar