AWE only comes into it if you have more than 4GB memory and you are using 32 bit.

I knew what you meant Grant.

Thanks for the feedback. 🙂

Ok, a bit of humble pie eating here.

this is the output from msdb..backupset. a full backup was taken followed by 3 tranlog backups. Nothing changed between the full backup and...

In my experience only the status column is of interest. If the value = 2 the vlf contains active transactions, if it = 0, it does not.

If status = 2...

Yogirk (9/2/2010)

---

I faced an interesting question in an interview the other day - the interviewer asked "We take transaction log backups we don't really have enough space to store them,...

always, always, backup your system databases. Difficult to recover a SQL instance without them.

well they would be in your backup of msdb.

you could also use SSMS to script them out to file, and use your offsiting process to include those scripts.

It's a good...

Rudy Panigas (9/1/2010)

---

This is my answer too. Although some DBA believe that the shut down for the OS does it quickly, not giving enough time to complete the write operations...

shutting down the OS down cleanly shuts SQL down cleanly, the end result is the same as stopping the SQL services first.

you would still want to schedule the OS shut...

mtillman-921105 (8/31/2010)

---

george sibbald (8/31/2010)

---

mtillman-921105 (8/31/2010)

---

I would think that it matters how often the tables would be joined when they were being used. If they always have to be joined...

mtillman-921105 (8/31/2010)

---

I would think that it matters how often the tables would be joined when they were being used. If they always have to be joined anyway, splitting them...

not anymore, you've got an n+1 cluster, same as everyone...

now referred to as an 'n+1' configuration by microsoft.

Microsoft refer to these as multi-instance failover clusters now.

for the simplest case of a two node cluster, it is where you have more than one instance of SQL installed on...

Sql Server books Online is a good place to start

look up backup database and dbcc shrinkfile.

I would say in this case you must shrink the log file to about 20%...