Just for the fun of it... I added a filter to ignore my latest 2 backups to simulate lost or corrupt backups files...

Still runs in less...

James Goodwin (5/4/2011)

---

You can try following scripts to shrink your database which I am using. However I only work with database having one ldf and one log file in MSSQL...

Happy to <almost> help :w00t:.

Ya set options + un-qualified (objects :hehe:) = a buttload of plans and wasted cpu cycles.

I could have understood 2-3 plans if you had vastly different amount of rows...

http://www.red-gate.com/products/dba/sql-virtual-restore/

Depends on what you need to run on the test server.

You could always restore a 2nd copy on prod, drop all NC indexes that are not keys. Then...

Ok, but I still don't really see the question and how I can guide you.

So you got a list of servers. You need to manage them. then what?...

CMS?

P.S. If it's THAT urgent then hire someone to do it for you.

This is advanced stuff and you should not start that project under pressure. And whatever...

that's only 10% free space. That's actually not much. I would consider increasing it in the next few months.

You definitely don't need to shrink that db.

kim.etcheson (5/4/2011)

---

We bought a vendor package where the vendor hardcoded the db logon and password in the application that we couldn't change on the database or the app wouldn't work....

Copy the 5 reports into a master report. that could get messy with 5 reports most likely all having report and page headers + footers.

But that would be a...

That seems way over your head... maybe you should hire a consultant for a day to get that done and do a health check of your server.

In books online DROP...

sql_lock (5/4/2011)

---

Sorry, but I dont have an easy solution for you... But here is what we do...

We have a 2 server dev environment. 1 is for our daily/weekly builds which...

Plan Z might be to simply script out the DB. Then use a data generation tool.

It could work for dev work, but QA would need to real data. ...