Hi,
Will the dbcc checkdb, dbcc checktable or dbcc checkcatalog causing the database lock? will another user able to access the db if I run this dbcc statement
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22633325.html
I use ADO in a VB app. One of the things I need to do in the app is backup the database using sql scripts.
I want to run run DBCC CHeckDB to verify the database before I do a backup first but m...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20030543.html
Under SQL6.5, sp_who2 reports that process_A (dbcc checkdb) is 'blkby' process_B. The blocking just sits there forever until I kill process_A. Questions for experts:
1. what kind of lock does DB...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20099342.html
When I try to remove a specific field from a specific table, I get a message:
'[tablename] - Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20118683.html
FOr sql server 2000, could anyone be as so kind as to show me a script in which I can run the dbcc checkdb with the repair-rebuild option with all messages shown??
This is very urgent.....
http://www.experts-exchange.com/Database/Miscellaneous/Q_21319247.html
Zones:
DatabasesDate Answered: 02/18/2005 Grade: A Views: 108
I need to run a checkdb on an MSDE database. I'm logged into the server running MSDE as an Administrator and typed the following at the command prompt:
c:\osql -E -d Mydb
and get the followi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21887814.html
I'm running Sybase 11.9.2, with raw partitions, on AIX. Is using "dbcc checkdb('dbname')" the best (I know it's not speed wise...but in reliablity) way to check the DB for integrity. What all doe...
http://www.experts-exchange.com/Database/Sybase/Q_22121975.html
Zones:
SybaseDate Answered: 01/21/2007 Grade: A Views: 85
Dear EE Experts,
Can I run a DBCC CHECKDB against a db that is in suspect mode? I am in sql2k.
Thanks!
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22391525.html
I've discovered that DBCC CHECKDB is runing on all my databases every hour on the hour. Is this a default behaviour? It takes 10 - 15 minutes for it to run on my production ERP database, and users ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22870647.html
What is the best way to run checkdb and new allow and have the results mailed to you using xp_sendmail upon error??
Thanks!!!
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10198586.html
