ondrej.bouda (5/14/2009)

---

Well, that's clear. I already mentioned RAID 1 as the only acceptable use of two drives (see my first post).

Anyway, how does it relate to giving mdf and ldf...

ondrej.bouda (5/14/2009)

---

Hey, what's wrong?

Consider a small firm: Could you please explain me why I should make my customer spend money for more disks while both users are content with...

I wouldn't think so. But, you should be able to do the...

psangeetha (5/13/2009)

---

David,

The backup is done to the local disk on the server and then to the tape.

I tried taking backup manually, but I get an error that...

Depending on the size of your shop. In "my world" developers...

Barkingdog (5/13/2009)

---

Bad habit: we generally copy our production databases into test and dev environments to supply "real world" data for testing. Our developers complain that if we used test data...

So, some questions about your backup process.

Do you back up to tape, to a local hard drive, or to a network drive?

If you were to manually run the...

psangeetha (5/8/2009)

---

I just looked at SQL server error log on the SSMS, I see this message for this SPID:

The operating system returned error 1450(insufficient system resources exist to complete...

psangeetha (5/8/2009)

---

Okay, if this is the only option then I should probably let everyone know that the databases will go down and bounce the SQL server service.

After the restart, if...

psangeetha (5/8/2009)

---

No.. I just tried to bounce the database. There are 7 other databases that are being used on the same server, so I wont be able to restart the...

Just to be clear, you stopped and then re-started the SQL service, right?

What is the SQL log saying? Is the database marked as suspect?

psangeetha (5/8/2009)

---

I only 2 processes open for this database with same Process ID. The status for both are suspended and the command is KILLED/ROLLBACK. Application is SQLAgent-TSQL JobStep (Job .......

psangeetha (5/8/2009)

---

But, the process is in suspended state since yesterday and I just ran the command again and the estimated rollback completion is still 13%. Is there a way...

psangeetha (5/8/2009)

---

Hi all,

I need to bounce the database and I'm stopping all the services connected to the database. I'm trying to kill a session as

kill 105 with statusonly...

And this is where the I, humble DBA am now. If I implement log shipping that would mean the production database will be available to User with no contention...