If I switch from FULL to the BULK-LOGGED recovery model, don't I lose what is currently in the transaction log?

andrew gothard (9/28/2013)

---

kevaburg (9/28/2013)

---

The only thing I can think of off the top of my head this:

There has to be a user executing the backup job. You could start...

Are you looking too deep into a simple problem?

Would this not provide the answer you need?

select name, size from sys.master_files;

Ideally you could break the empty RAID5 and use the disks to physically separate the differing datafiles.

TEMPDB should definitely have its own spindle and ideally the log files...

A very good friend of mine, a successful developer and DBA...

dkrasnikov (9/28/2013)

---

eddie.caplan (9/24/2013)

---

Joshua Feierman seems to think the developers are supplicants, pleading for help. In fact, the DBA should think of the developers as his customers, and provide better...

The only thing I can think of off the top of my head this:

There has to be a user executing the backup job. You could start by preventing this...

Kurt W. Zimmerman (9/27/2013)

---

I find this question somewhat puzzling. All of my backups go to a designated backups folder. I have never created a backup in an unwanted...

Kurt W. Zimmerman (9/26/2013)

---

Hold the phone here.... you are placing a stereotype on DBAs which I don't really agree with.... I have played the role as DBA for a very...

My interest in this theme is based on the fact I have an upcoming migration to SQL Server 2008R2 and I have 2 NetApp storage appliances with 20TB each. ...

This is possible using the SSMS although it is a little more involved.

From the command line run osql -L to search the subnet for available servers. The SQL Browser needs...

GilaMonster (9/25/2013)

---

That's...

Although it isn't possible as Gail has said with zero downtime I have done this using mirroring and I managed to complete the process extremely quickly.

What I did was:

1. ...

SQLSteve (9/25/2013)

---

Personally, for TEMPDB i have all of the files on the same drive by default. They are always on their own dedicated drive though.

For the Data and log files...

Eric Higgins (9/24/2013)

---

eddie.caplan (9/24/2013)

---

Joshua Feierman seems to think the developers are supplicants, pleading for help. In fact, the DBA should think of the developers as his customers, and provide...