Good deal, i've got a nice little script i use to see the db size and log size and % used (*this is only good on 2005 & 2008,...

if you type in

dbcc sqlperf(logspace)

what are your results?

if your backing up the log you should be able to minimize the log growth, but if the log does need to...

Hey Sunil,

I'm going to do this by using the GUI

1. Right Click on the database you want to restore

2. Click Tasks | Click Restore |Click Database

3. put in all...

Agree you need to take into account Business rules and other systems that may have dependencies on one another, as well as capturing the performance counters.

At my last job we...

in the script put

use [databasename];

go

[insert remainder of the script]

What version of SQL Server are you running?

You will need to open up a new maintinace plan, and have the steps within the plan follow the type of steps done...

I understand this may sound overly cautious, but if you store SSIS packages on the server then there is always the chance that someone could hack in and get the...

agreed. I've been talking with my SA's about that. They manage a 3rd party software that manages the alerts for all the servers, and they have only 1...

Hey Leo,

If you do a search on performance counter on SSC you will get plenty of results, but here is the first one in the list...

Hey All,

I've got a server with 8GB ram, it is using an unusally high amount 7.2 GB, but my hardware counters are fine (New DBA I...

never mind, was freaking out and logged into the wrong server.......this is what waking up at 3am to do upgrades will do to you....

move along....nothing to see hear......

Agree with SS I just ran into this on a cluster upgrade from 05 to 08. At first "The Service" error they were talking about for me was...

Thanks a million Gail!

Hey Gail just to clarify should i delete the system auto created statistics or should i just run sp_updatestats and update...

Tim Walker (4/15/2009)

---

Hang on. Can I start from scratch...

If you have an upgrade from 2000 to 2005 you may well have some compilation differences.

One good way to detect this (after...