Wednesday, June 12, 2013

[MS SQL Server] Error Runnind DBCC CHECKDB('databasename')

[MS SQL Server] Error Runnind DBCC CHECKDB('databasename')

Error Runnind DBCC CHECKDB('databasename')

Posted: 12 Jun 2013 02:39 AM PDT

I'm getting the following error when running dbcc on a database server containing three different databases. Two of the commands run fine execpt for this database. What is the best way to handle this? I read different suggestions and one of them is to restored from a backup file, would that be a good solution?Executing query "USE [TestDB] ".: 50% complete End Progress Error: 2013-06-12 00:01:09.92 Code: 0xC002F210 Source: Check Database Integrity Task Execute SQL Task Description: Executing the query "DBCC CHECKDB(N'TestDB) WITH NO_INFOMSGS " failed with the following error: "The In-row data RSVD page count for object "table1", index ID 1, partition ID 306297224822784, alloc unit ID 306297224822784 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE. The In-row data RSVD page count for object "table2", index ID 1, partition ID 369221408063488, alloc unit ID 369221408063488 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE. CHECKDB found 0 allocation errors and 1 consistency errors in table 'table1' (object ID 378757448). CHECKDB found 0 allocation errors and 1 consistency errors in table 'table2' (object ID 1338904287). CHECKDB found 0 allocation errors and 2 consistency errors in database 'TestDB'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Progress: 2013-06-12 00:01:09.94 Source: Check Database Integrity Task

Different set of access to different users under same schema

Posted: 11 Jun 2013 06:55 AM PDT

I am working on a sql database which has multiple schemas. Lets say schema 'XXX' has 50 tables and i have 3 set of globalgroup users accessing this schema. Can i restrict the table select/delete/insert/update at global group level? For instance users belonging to group A should be able to create/modify/delete/insert /update table or records. Group B can only select data from all tables and groupc can select only 10out of 50 tables.is this doable? If so a user with db_owner privileges can set these up? Any input or ideas are greatly appreciated. TIA

Copy backup files

Posted: 11 Jun 2013 11:28 PM PDT

Hi Experts,I need to copy backup files of around 500GB from one location to another,need to check the existing file date and available disk space then only i need to copy the files. Can anyone please help?Thanks in Advance

User Connection Memory - Memory Leak??

Posted: 12 Jun 2013 01:50 AM PDT

Hello,I have had an issue on a SQL and SSRS server that i have been unable to resolve without getting someone to restart the application services to drop and recreate the TCP connections made to SQL. I have used Quest to look into this but can find very little apart from which SPID it is and where it is coming from.We are using WebSense and on the server there is one TCP connection of concern, that at the start, has a memory allocation of 2....and 10 days since that restart....it is 474,849....which equates to around 3.8GB. We have a MIN and MAX memory setting of 4.8GB.Currently we have 3MB for the procedure cache when it was originally just under 2GB....and 1GB for the buffer cache where it was originally just under 2GB also. This is not a heavily used server so luckily the performance impact is minor. However, since yesterday the alerts for recompilation (all <40%) are driving me crazy!! The procedure cache is shrunk all the way down....and once the procedure cache is down to its smallest, the buffer cache starts to suffer and lose its allocation.I refuse to stop the alerts on this server just to make it quiet. I have checked the DBCC MEMORYSTATUS which gives very little information that i have already. The MEMORYCLERKS DMV shows 3.7mil [b]single-pages[/b] for SQLCONNECTIONPOOL. ReportingServices is only using 150MB and doesnt seem to be used much anyway.I have logged a call with WebSense but they dont seem to have any idea what could cause this. I was hoping someone here could point me in the right direction or to assist in trying to get more imformation, and more importantly, a way to show WebSense, or myself, the cause of the issue and hopefully resolve it.I have read that something using prepared statements can cause a memory leak....but unsure how to find any evidence for this.The server details are:Windows 2008 R2 SP1SQL 2008 SP3 Enterprise (10.0.5500)2 x vCPU8GB vRAMI saw another post relating to a similar issue but no answers. My memory usage graph is a dead straight line with no deviations....meaning the consumption was constant. I would not expect the WebSense logging utility to be as busy during the day as at night so was thinking this was not related to the SQL activity....more along the lines of the type of connection or something in the application....but again.....how do i show this?Any help would be much appreciated.Regards,Samuel

ShrinkFile on Varbinary column

Posted: 11 Jun 2013 04:08 PM PDT

Hi,I need a help. am doing shirnk on 160gb( but data is just 30gb) to claim space. This db has Varbinary columns. Shrinkfile for 1GB (Dbcc shrinkfile ('Filename', 159) takes 35 minutes and i had to kill it since it blocked other session.have you anyone faced this problem when shrinking varbinary data? Do you have any better idea to reclaim space.? thanks

unable to connect to server ...

Posted: 11 Jun 2013 11:24 PM PDT

From time to time our front end application gets 'unable to connect to server: abc' error. The error just goes away on its own. We tried to increase max worker thread, which did not help. Could someone point me to the right direction? FYI, we are on sql 2008 R2 standard.

Having backup problems, and unable to change service accounts...

Posted: 25 May 2013 07:02 AM PDT

Two problems, possibly related, both giving me heartburn as I'm going away for 2 weeks and don't want to leave a server in this state...Problem 1:When I try to run a backup to anywhere *EXCEPT* the default SQL backup folder (\program files\microsoft sql server\mssql10_50.mssqlserver\mssql\backup\) fails with a system error 5 (Access denied.) Now, the SQL Server service account is a member of the local Administrators group, and I've checked the permissions and there's nothing that should be blocking it.Problem 2:When I try to change the service account to any other account, I get a "wmi provider error - Access denied - 0x80070005" message. All the solutions I've seen for this say "click on the browse then key in the account name and "check name" and re-enter the password." Well, no dice, same error. Even if I try to use one of the local system accounts, same error.I'm logging into the server with a local Administrator account, so I have the rights to do this stuff. It was all working before I installed some Windows updates, since then it's gone pear-shaped. I've tried uninstalling the updates, that hasn't helped. I've got 2 other SQL Servers, identical configurations (same OS version, same SQL version, heck everything is installed to the same places!) which are [b]NOT[/b] having this problem.I've been Googling this problem most of today, and it's PISSING ME OFF!(sorry about that)Any help, any suggestions will be deeply appreciated.Thank you,Jason
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog