Reds and Tigers series are 2-2... Today decides it.

I ran the DBCC LOGINFO() and found a lot of growth fragmentation in the files. I had the mdf and ldf file growth too low and when I rebuilt...

... all I know is that my Red's are up 2-0 against the Giants. 😀

Don't forget the watch to see if Miguel C. is going to be the first Triple Crown Winner since 1967.

My Red's are limping into the playoffs.... sigh. Lowest number...

For a Non Clustered SQL Server:

Test this all before you do production of course. Take db backups of all dbs before you do this as well and test, test,test...

Thanks for the link SpringTown... I hadn't found that article. I have opened an incident with MSFT and have yet another meeting with the storage gang today. The...

That isn't good.

Look at the SQL Server log as the previous poster stated

Also look at the Windows Application and system log. There has to be more detail there.

jamessdba (9/24/2012)

---

Hi,

In one of our servers(sqlserver 2005 ent edi) all maintenance plans(scheduled db backups) running under sa login & pwd

we have changed the sa password

now all maintenance jobs...

So, as it stands today what teams are the 'surprises'....

Positive:

Baltimore battling for the division lead against the Yankees?... who would have thought.

Oakland battling for the Wild Card.

The Reds in 1st...

Yea,...

If you are saying SQL Server for one instance is different for the other collation wise then the easiest way (if the SQL2008R2) if it is not being used simply...

Run this and post your results:

DBCC CHECKDB (YourDBName) WITH NO_INFOMSGS, ALL_ERRORMSGS

Yes, tell us what errors you are seeing or why you think it is corrupted. Does it show SUSPECT next to the DB in Mgt Studio? What errors...

Are you going to do an upgrade in place.... stand up a new server with SQL2008? Depending on what path you take will make your back out if something...

Ray K (8/22/2012)

---

roryp 96873 (8/22/2012)

---

on topic .... That is why I love the minor leagues. Not only does it allow me to watch pro baseball here in Montana (I...