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...

I'll still stand that allowing someone to modify code on the server is a fundamental design flaw. It's reality, but it's a problem.

The live code is on the server, but...

If backup exec writes the backup time before it's finished, that's an issue. Certainly you might not be able to rely on this for restores at that point.

I think Idera,...

I'm sure that's my...

Edge has a number of issues, but it's such a low priority that we aren't spending significant time working around it.

sqlcmd -S servername -E -d Databasename -i c:\abc.sql -o c:\abc.txt