I would install the service packs on a QA or Dev box before doing it on production.

First you need to find out what build you currently have. It...

Not quite sure if this is what is happening but....

I would assume the reason it is failing is because a particular job that is trying to be moved is failing....

I had the same problem using linked servers and full table locks. Our solution was to get rid of the linked servers and and put the two databases on...

I wouldn't put another instance on a production box in the first place.

Idera sql diagnostics manager is what I use and it works well. Redgate also has tools.

I have a similar problem with reporting services and biztalk. Currently i'm using the datasource connection string:

Data Source=myserver;Initial Catalog=mydb

I need to somehow put the failover partner in the connection...

I also have this problem and am guessing it is because of deadlocks:

2008-08-08 10:19:48.39 spid4 Victim Resource Owner:

2008-08-08 10:19:48.39 spid4 ResType:ExchangeId...

Thanks all.

I found my problem... My 2nd database was from a backup taken off of a sql 2000 server. I had to take another backup of it after...

You may want to rephrase your question.

Are you asking what you should set the autogrowth to be? or Are you asking how big your database is going to...

I had to schedule the maint. plan to get it to show up on the jobs.

Have you tried a "group by"

You could always move the files. I use the below script to move tempdb to a diffrent drive other than C:

use master

go

Alter database tempdb modify file (name = tempdev,...

This worked for me! Thank you!!!