The master key has absolutely nothing to do with moving the database!

You need a backup of the certificate and its password and the database backup itself. The master key merely...

Roust_m (5/9/2012)

---

Hi,

I want to define a policy to make sure every table and every index (including those for indexed views) in the database has "PAGE" compression.

I could only find a...

the cluster will replicate this change for you, just apply at the active node

Instead of using sysindexes, use sys.indexes and sys.objects

The first thing you want to do is to get...

what do the jobs actually do??

Try setting the log output on the job steps to get more info too

Roust_m (6/19/2012)

---

Just to save on licences. I spoke to Microsoft licencing specialist and he told me that as long as you set affinity to certain CPUs for both EE...

Roust_m (6/18/2012)

---

but since Standard Edition only supports two node cluster, would it still be possible to install it on a four node cluster and just limit Standard Edition instaces by...

Check the status of your mirror sesion firstly, log records that have not been transferred cannot be truncated and often cause the log to grow wildly.

Also check the status of...

Ratheesh.K.Nair (6/18/2012)

---

Hi Achtang,

Again you have to restore the new master with your master backup file otherwise it wont read your user databases it will all greyed as ur new master...

You should definitely be looking to consolidate here where possible.

kevinsql7 (6/15/2012)

---

What are the latest Service Packs for SQL Server 2008 and SQL Server 2008 Release 2? And if I apply the latest SPs do I need to apply any...

kylemkr85 (6/15/2012)

---

Hello,

I have a question regarding an ACTIVE/ACTIVE Cluster enviornment using SQL Server 2008 R2. We have several instances of SQL which we currently need to migrate from SQL 2005...

ganeshkumar005 (6/13/2012)

---

Log shipping experts - pl help.

After feeding all the things in log shipping configuration monitor, what I get is Alert job and log backup job created on Primary but...

it's also vital to get the server name correct in the linked server. You may even have ports...

check the application event log for further sql server startup error messages and post them back