calvo (8/22/2012)

---

off topic .... duh! This thought crossed my mind...

Nationals...Personally I'd go with the advice of the trainers and everyone in the front office. They know the pitcher well, what he has pitched in the past innings wise...

Yes.... on the inactive node stop all unneeded services like backup software, AV, etc.... run the upgrade to SP3 and it will update the binaries and will run rather quickly.

When...

Thanks a million gang.

The problem I have is that the Service ID for SQL Server is not log on able... so... I use my Admin ID to log onto the server, install SQL...

I tend to agree with others. EXAMPLE: Just because you have a 200mb db and split the data up evenly (or so you think) into 4 50MB data files...

I agree completely with you. A full db backup is the way to go. Especially if something goes wrong and you need to restore. The last thing you...

If you are asking about the difference between installing Management Studio to be able to query a SQL 2008 DB then No... there is not just client to query a...

My guess is that a checkpoint within SQL Server needs to happen to recognize the transaction is complete and will flush the data out of the transaction log. Are...

Greg Milner (9/6/2010)

---

I have been a DBA for 10 years now and I never use the DTA. In my opinion, if a person cannot determine whether an index is needed,...

We have the same account to run SQL Server for all production and a seperate ID for non production. I was going to have a new account created and...

It is stuck in this state since you canceled the restore. Once a restore has been started you cannot undo what the restore...

OK, thanks. Seems odd to me that they will allow you to save it in MSDB but never open it or alter it ever again.

BEFORE you move off of SQL 2000 run these against the databases. If there are any errors do NOT backup/restore to SQL2008, fix the errors first.

DBCC CheckCatalog

go

DBCC CHECKALLOC

go

After you...

Thanks for both replies. I got it figured out before your replies.