You do in order to decrypt the cert for the backup on the main instance.

Do you not know the password of the cert? Is it not in any VCS or...

Tony Lanterman (2/5/2016)

---

For us, the push to get off SQL2005 over the last year hasn't been to get away from SQL2005 as much as to get off the Windows Server...

Yep, Jeff is right that you can use redirection from a command line.

If you need to do this inside SQL Server, you can use xp_cmdshell to call this in a...

roger.plowman (2/5/2016)

---

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is missing a join...

FunkyDexter (2/5/2016)

---

3. They usually required a change to be scripted. Really? I'm in SSMS with nice graphical designers and you would me to ignore all that gui goodness and...

djackson 22568 (2/5/2016)

---

I corrected your type. I am sure...

BenWard (2/5/2016)

---

SQL 2005 all the way!

I have MI applications running on 3 SQL Servers and they're all 2005 (one of them was originally written for 7 and got ported to...

Stuart Davies (2/5/2016)

---

Most of ours are, in fact there are still a couple of 2000 boxes and one 7.

They run well but like Ed said, the hardware is the flakiest...

The add-in is here: http://www.red-gate.com/products/sql-server-central/plugin/download

This was a side project from one of our developers and gets access to scripts (your saved ones and all others) from inside SSMS. The dev...

Can you provide a little more detail on what you mean? Are you accessing SSRS reports using the Report Service Web Service?

Maybe you can give some specifics?

Did someone cancel the growth operation? If not, then you may have IO storage issues. The files need to be able to grow if they need space in an emergency....

If BackupExec sends raw T-SQL, that's weird. Do they then whack the local files once they've copied them to their own system or are they left there?

Nothing wrong with using...

ccd3000 (2/4/2016)

---

IMO and experience, weak management has usually been the biggest problem in IT, no matter the size of the organization. Like you said, losing the factory mentality is critical...

True, it's not DR, but it's better than nothing. Always keep an old backup while the new one is run.

I wouldn't recommend snapshots as DR, nor did I mean to...

It's...