|
|
Posted by Erland Sommarskog on 08/07/06 22:07
tommy2 (tommy2@ptd.net) writes:
> This database used to run on NT 4.0 6 months ago. They moved it to a
> win2003 server. It ran fine since being moved up till last week.
Wonder if that was just pure luck? I happened to look at
http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx today. It does
not talk about 6.5 on Win2003....
Anyway, if their transaction log grows in size, there is some activity
going on, but what I cannot say from a distance. Did you try running
any of:
>> Try running this from a query window:
>>
>> sp_spaceused syslogs, true
>>
>> I would be interested in seeing the output, at least if the problem
>> persists. It could also be interested in seeing the output from
>> sp_helpdb.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|