Viewing 15 posts - 826 through 840 (of 2,387 total)
Something more.
Login Failure
Processes with high waittime and the last waittype
Eventlogs
SQLServer:Access Methods - Full Scans/sec
SQLServer:Databases Application Database - Transactions/sec
SQLServer:Memory Manager - Memory Grants Pending
SQL Server Services
Cluster SQL Server Resources
Tracking high-resource queries
Replication
Log...
November 24, 2003 at 5:22 pm
November 19, 2003 at 2:36 pm
Can you ping the server name? Try to register them with ip address instead of server name.
November 19, 2003 at 1:33 pm
Create a stored procedure to run dbcc showfiles in remote server and call it from local server like exec remote.master.dbo.usp_showfiles.
November 19, 2003 at 1:27 pm
You can't perform log backup in simple recovery mode. Completed transactions in transaction log will be truncated at checkpoint by system automatically. You can only recover the database from last...
November 19, 2003 at 1:23 pm
The index ID in error messages indicated which indexes are in problem. Drop the indexes, recreate them and run dbcc checktable against these table.
Please post the result of dbcc checktable.
Edited...
November 19, 2003 at 12:49 pm
quote:
the "size" is not accurate either.
Why?
November 19, 2003 at 12:15 pm
I would run dbcc checkdb without parameter to see which tables have allocation and structural errors and go from there.
November 19, 2003 at 10:00 am
Strange. Can you check back the log file size by running sp_helpfile in your user database.
November 19, 2003 at 9:57 am
Make sure your run them in the correct database, ie your user database.
November 19, 2003 at 9:41 am
Do you mean the log size hasn't changed after the shrink? Which version of SQL Server do you run?
November 19, 2003 at 8:56 am
select object_name(yourobjectid) will tell you the object.
sp_helpindex yourobjectnaem tells the indexes the object has.
November 19, 2003 at 8:53 am
quote:
We do not have a Domain Server so I guess i am forced to use Local System Account flex_sql.
November 7, 2003 at 2:45 pm
I perfer to break the huge update into small batches as Guarddata recommedned.
Edited by - allen_cui on 11/07/2003 2:40:56 PM
November 7, 2003 at 2:41 pm
They could be in one of domain group which is the member of your local administrator group.
November 7, 2003 at 2:36 pm
Viewing 15 posts - 826 through 840 (of 2,387 total)