In this case you can fix the missing tran log backups issue by taking a differential backup on the primary and restoring...

Akayisi (1/22/2014)

---

Hanshi my bad, nobody can delete it accidentally.

ok now i want to know this.

Suppose that i have trn files which are 1.trn, 2.trn, 3.trn

I know for sure that...

schleep (1/22/2014)

---

What isn't working is getting SQLCMD to run in the context of the user that's login in/out.

I had assumed that the policy would execute under a system/admin account.

But...

logicinside22 (1/21/2014)

---

Hi guys

we have Active/passive SQL 2008R2 cluster environment.

looking for steps to move Data and log files from user Database and System Database for SQL Server Clustered...

Makes absolutely no...

muthyala_51 (1/22/2014)

---

I used the command COMPACT /C /S source destination to compress all the read file groups. It worked fine. But I...

Are you using Log shipping or your own variation of it

What steps have you taken so far?

Create a new thread detailing the current setup and I'll be...

Talib123 (1/20/2014)

---

Perry Thanks, but the query didn't return anything. I am running my backups via Maintenance Plans (SSIS).

Hanshi I need the script to run via my CMS to see...

If you have a central management server configured you could group execute the query there across pre defined instances

Symantec do offer a VCS management pack for SCOM

This is not an old option, it's perfectly serviceable to deploy a single small clustered instance of SQL...

Really and why exactly is that?

I believe it is a fairly quick operation based on another users experience of this