View Complete Post
does DBCC CHECKDB actually repair the SQL Database??
if so, could someone give me code on using the command?
I am using the Express version of SQL Server, 2008.
Hi Guys
I am new to SQL Server Administration. I have set up the Backup jobs according to the requirements from the Application team. Also I have set tip the update stats, Reindexing Job every 2 weeks as far as the maintenance as maintenance is concerned. I am using SQL Scripts in the SQL Agent to perform all these jobs
But i have not scheduled any Integrity Check (CheckDB ) Jobs on any of the database in any of the servers. I have databases of Size 1Gb-50 GB and few from 100-600 Gb.
I want to set up the integrity jobs on all the databases. Can you please suggest me some best ways how I can schedule jobs every 2 or 3 weeks on small databases and on big databases like 100 - 600 GB in SQL Server 2005,2008.
Thanks
Hi
I'm having a couple of problems
I have a list, List A. On a couple of triggers I want list A to copy fields to a new record in List B.
Many of the columns are the same Say, column1, column 2, colmn 3. The Copy Item is working fine.
BUT
I then want to amend several fields in the new record in List B to reflect the new info from list A, and create info in a fields (say ListBcolum4 type choice and ListBcolum5 single line).
For the life of me I cant get this to work... ive tried updating fields, creating items...
A pointer on how to do this would be greatfully received.
Having come from the MS Access world, many people wonder if there is a similar tool in SQL Server or SQL Server Express that mimics the Access Compact & Repair.
Although it is possible, I've read that it is not best policy to regularly compact and repair SQL Server databases using DBCC SHRINKFILE (compact) and DBCC CHECKDB (repair).
Can anyone tell me why running these commands would be a bad thing? What would be a better plan of attack especially for small companies with minimal staff and maybe not even a resident DBA (i.e. typical users of SQL Server Express).
Thanks.
Hi Friends,
could you please provide the solution for below error,
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8646911284551352320 (type Unknown), page (289:0). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916873 and -1.
Repairing this error requires other errors to be corrected first.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8646673261154795520 (type Unknown), page ID (3:240120) contains an incorrect page ID in its page header. The PageId in the page header = (0:34871552).
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8596527261321199616 (type Unknown), page ID (3:313995) contains an incorrect page ID in its page header. The PageId in the page header = (16249:36607).
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8430570274608381952 (type Unknown), page (42240:-1694459136). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362441 and -1.
Repairing
As part of of the DR testing for the company I work for, we have to take a database backup file and restore it to a different instance on a different server and then run DBCC CHECKDB. In this particular case one of the databases that needed to be tested was a master database (2008 not R2). I recovered the 2008 database to our DR server (which already has a named 2008 instance up and running) and the restore completed successfully, however when I ran DBCC CHECKDB ('XXXXXX_master') I received the following output:
DBCC results for 'XXXXX_master'. Service Broker Msg 9675, State 1: Message Types analyzed: 14. Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. Service Broker Msg 9667, State 1: Services analyzed: 3. Service Broker Msg 9668, State 1: Service Queues analyzed: 3. Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0. Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3851, State 1: An invalid row (class=12,depid=0,depsubid=0) was found in the system table sys.syssingleobjrefs (class=12). Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3851,
Hi All;
I would like to set a job for a health checking. I want to run the command DBCC CHECKDB for a number of databases. So how the script will gonna be? Is the below one is correct:
USE DB1
DBCC CHECKDB
GO
USE DB2
USE DB 3
will this run the first DB then will go to the second one? What If there is any error in the first dbcc checking? How would I know? Is there is a possiblity to send the results to Excel/.txt file for each database?
Weekly integrity check jobs for one of our critical databaseÃÂ are failing with the following Error. We fixed the error by DBCC CHECKDB ALLOW DATALOSS. But again the integrity job is failing for other tables. When we check the object_name of objectid it wont be there in sysobjects or database. We checked the disks using chkdsk, no bad sectors found.ÃÂ Database is on SQl Server 2000 instance, having Service pack 4 applied.ÃÂ Please suggest.[1] Database XXX: Check Data and Index Linkage...ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 2576: [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (3:51165) object ID 1275867612 index ID 0 but was not detected in the scan.ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (1:424) object ID 1275867612 index ID 9 but was not detected in the scan.ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (1:481) object ID 1275867612 index ID 10 but was not detected in the scan.ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous poin
Hello!
I'm using Asp.NET 4 to perform a simple query on database. But when navigating to page that needs data (i'm using SqlDataSource) i receive this internal error. I already ran DBCC without error and i still have the issue.
Windows 2003 Standard with latest updates 32-bit Sql Server Standard 2005 SP4
The same query, executed from SSMS works fine.
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend