roryp 96873 (3/26/2013)

---

Markus (3/26/2013)

---

Hoping to check score once in a while.... My Red's aren't looking good at all in Spring Training.... 9-18. Hope they get better when...

Hoping to check score once in a while.... My Red's aren't looking good at all in Spring Training.... 9-18. Hope they get better when the bell rings...

I had this type of issue what a 100gig db that I was trying to back up. It would get so far and then the backup seemed to just...

Even better. Thanks.

Great script. Thanks a million.

That is WAY too long. Should take minutes. Look at the SQL Server log and see what happened and the Windows event log for clues as to what...

We took over a company some years ago with 100 SQL2000 dbs. CHECKDB was never run. I found two that had minor corruption that would have not allowed...

We use dns aliases for this purpose. Although, we DO have some app folks that ping that name and find out the real name and use it. Frustrating...

That I don't know. Never tried it.

We renamed a Win2003/SQL2005 server years ago. I left that the way it was and it has been fine for years.

May sound like a dumb idea but have you done a test email send via the database mail GUI? Does it send that way? If not go back...

Typically I hate the small initial size of the system dbs and the percentage growth. I change master, model, msdb to grow by 10MB for mdf and ldf. ...

Like a previous poster stated It depends... it really does... the age of your server, memory, high cpu when you are running the restore... high or low I/O operations....etc...

I...

You should really run the integrity check nightly and have it email you if it fails. That way you have a good backup to restore from in the future...

TEST, TEST, TEST... hope you have a test environment and just aren't upgrading production.

Biggest things are:

Rebuild Indexes so optimizer sees the indexes

Update Stats 100%

CHECK Integrity, this makes sure there is...