Peter Schott (6/19/2013)

---

I'm blessed to work with another DBA who subscribes to the ideas behind the "lazy DBA" philosophy - don't work harder/more than you have to. He set up...

batgirl (6/19/2013)

---

kevaburg (6/19/2013)

---

What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been...

Gary Varga (6/19/2013)

---

kevaburg (6/19/2013)

---

What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have...

Please read through the backup docs more carefully because your understanding of Recovery Models is completely wrong!

The Full model maintains a transaction log so that point in time recoveries are...

Sounds like you might be talking about PowerShell integration for SQL Server.

Lowell (6/19/2013)

---

it depends on why the job fails i guess;

one possibility might be to have the job use SET XACT_ABORT ON, and put it in a transaction; then if an...

GilaMonster (1/11/2012)

---

Which only works if the database was shut down cleanly...

I would be more inclined to send an Email notification to an operator if the job fails. Do you really want to trust the restoration to an automated job...

Are the two machines no the same subnet? If not then there might be an ACL on a border router blocking the port.

[/url]

Nonetheless.....I think there are better ways to recover than using EMERGENCY MODE. And restoring from a good backup is one of them, if of course you have one!

Good luck!

Having seen this entry, could your Windows Server be 32-bit? Or maybe the Windows Server is 64-bit but the SQL Server only 32-bit?

AWE Allocated ...

How long has this been a problem?

Has your SQL Server undergone any major changes either at the instance level or database level?

How much memory is allocated to the offending instance?

What...

What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been trained and...

GilaMonster (5/26/2013)

---

shohelr2003 (5/25/2013)

---

Actually I check log space regularly and take a log backup when necessary because there are some processes in my application that cause log file to grow larger....

The only thing I like to do with maintenance plans is run SQL that I have written myself. I have a couple of plans that are run on-demand (out-of-line...