Eric M Russell (1/9/2015)

---

There are probably a lot more multi-TB instances than there are multi-TB databases. I don't currently manage backups, but in our environment we have a 10 TB...

GBeezy (12/29/2014)

---

I'm not 100% for sure, but it was giving me, "there's another process using these files" and I could either try again, skip or cancel. It was almost...

Measure workload during normal business hours. You can use Perf. Mon for that. One or two weeks should be ok, but no less than that. I prefer Extended Events instead...

mtillman-921105 (11/1/2012)

---

To what extent can performance be isolated on the same VM for different SQL Server servers? So if I have a SQL server called Quantum and one called...

Dave Mason (11/20/2014)

---

One of our production servers (a SQL Server host) was "cloned" to make a secondary test environment. The source server is a virtual machine (VMWare vSphere environment) joined...

Would it make any major performance impact to only have 1-2 virtual drives per SQL server to handle the various data/log/tempdb files vs the current setup? What do you all...

Shawn Melton (11/13/2014)

---

I am not sure what the actual question is here but if you are referring to David Klee's presentation you can re-watch it on PassTV here.

The main point...

Sounds like a permission issue to me. But posting the actual error may help.

I use powershell. Like this:

$Path = "D:\MyPath"

$CurrentDate = Get-Date

$DatetoDeleteFULL = $CurrentDate.AddDays(-14)

$DatetoDeleteDIFF = $CurrentDate.AddDays(-7)

Get-ChildItem $Path -Recurse -include *_FULL_*.sqb| Where-Object { $_.LastWriteTime -lt $DatetoDeleteFULL } | Remove-Item

Get-ChildItem $Path -Recurse -include *_DIFF_*.sqb| Where-Object...

trayalacheruvu (10/7/2014)

---

Hi All,

Good Day. Primarily we have WH Solution in place running with the back end of SQL 2005 on Windows 2003 Server. Recently we have upgraded databases from SQL...

Grant Fritchey (10/15/2014)

---

sql-lover (10/15/2014)

---

Thanks for reply Grant.

Wow, that...

Thanks for reply Grant.

Wow, that was useful. It's...

A reboot may temporary fix the problem but you need to find out which...

FULL, and DIFFERENTIAL backups do not break the LSN log chain, so you can have Log Shipping and it will be ok.

Now, it is a horrible idea to keep your...

It depends of the workload and type of operations.

In data warehousing, which is basically the type of databases I have, I've seen Indexes with columns on 80% or more of...