Thursday, August 8, 2013

[MS SQL Server] Possible Corruption

[MS SQL Server] Possible Corruption

Possible Corruption

Posted: 08 Aug 2013 04:05 AM PDT

We had a disk drop and come back today that holds filestream files. I ran a DBCC CheckDB and it reported no allocation errors and no consistency errors in the database, but I am unable to do a log backup or differential backup. I get the errors...Msg 3634, Level 16, State 1, Line 1The operating system returned the error '21(The device is not ready.)' while attempting 'FsFileHeader::Read' on ''.Msg 5172, Level 16, State 70, Line 1The header for file '' is not a valid database file header. The File Header property is incorrect.Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.I am able to open the database and return query results from it. Anyone come across this before?Thanks,Josh

Is it possible to configure a trace to only keep X days worth of trace files?

Posted: 08 Aug 2013 02:10 AM PDT

The reason I ask is, my employer requires setting up a trace to record certain events (they follow the DOD STIG guidelines...) and they require that the trace files be kept "online" for at least 30 days.The problem is, the various SQL servers generate *wildly* varying numbers of records in these traces. One server might generate a couple hundred a day, not rolling over to a new file for weeks, while the Sharehog / I mean Sharepoint server generates 50k+ in less than an hour.So, currently, every so often I have to log into a server and delete old trace files. I'd set up a scheduled Windows task to do the deletes, but they've also got Group Policies in place that prevent saving credentials, so I'd still need to manually run the job...I could probably do an Agent Job with a CMDExec step and a proxy (which are also forbidden without a good reason,) but then I'd have to deal with the hassle of getting the OK for a proxy...If it isn't possible (and from what I've found, it's not) to set a trace to keep X days old of files, then maybe this would be a feature MS could look into adding to SQL Server at some point...

Moving Files between FileGroups

Posted: 08 Aug 2013 12:22 AM PDT

Books Online isn't very clear on this subject and Google-Fu suggests that what I want to do should be possible, but I can't find any examples to assist me, so I'm hoping people here can help.I want to move a file in a Secondary file group back to the Primary file group. This is cleanup. The database in question is getting upgraded and moved to a better server with a single drive, so we don't need multiple files & file groups in multiple locations. I know it's an ALTER DATABASE statement, but MODIFY FILE only allows me to modify the name and file size, not the file group it's hiding in (that I can see). And trying DBCC SHRINKFILE with EMPTYFILE fails because there are no other files in the Secondary file group that the data can be moved to.Can someone point me to a link or give be a better search term than "moving data between filegroups"?

difference b/w installation of SQL Server 2005 and SQL server2008R2.

Posted: 08 Aug 2013 02:16 AM PDT

Hi All,Can some one tell me the difference b/w installation of SQL Server 2005 and SQL server2008R2.Thanks,Santosh.

Install failed SP2 for 2008R2 SP2 on one node in a 2 node SQL Cluster Environment although build number updated

Posted: 07 Aug 2013 09:33 PM PDT

I have installed SQL2008R2 Service Pack 2 on our Passive node succesfully. We rebooted that, failed over the cluster so the now Active node was the SQL Server just upgraded. The install on what was the active/now passive node failed. From the Summary.txt file we have:Overall summary: Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files. Exit code (Decimal): [b]1209309228[/b] Exit message: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files. Start time: 2013-08-08 07:47:41 End time: 2013-08-08 08:16:12 Requested action: PatchInstance MSSQLSERVER overall summary: Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files. Exit code (Decimal): [b]1209309228[/b] Exit message: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files. Start time: 2013-08-08 07:53:29 End time: 2013-08-08 08:16:06 Requested action: PatchI have examined the details.txt file but all I can find is:2013-08-08 07:53:29 Slp: Sco: Returning service status Running2013-08-08 07:53:29 Slp: The following NT service was in a running state prior to patch action: ReportServer2013-08-08 07:53:29 Slp: Attempting to run patch request for instance: MSSQLSERVER2013-08-08 08:16:12 Slp: Error: Failed to run patch request for instance: MSSQLSERVER (exit code: 1209309228)2013-08-08 08:16:12 Slp: Sco: Attempting to get service start mode for service SQLBrowser2013-08-08 08:16:12 Slp: Invoking QueryServiceConfig Win32 API for buffer size2013-08-08 08:16:12 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer2013-08-08 08:16:12 Slp: Sco: Returning service start mode Automatic2013-08-08 08:16:12 Slp: Sco: Attempting to get service start mode for service SQLBrowser2013-08-08 08:16:12 Slp: Invoking QueryServiceConfig Win32 API for buffer size2013-08-08 08:16:12 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer2013-08-08 08:16:12 Slp: Sco: Returning service start mode Automatic2013-08-08 08:16:12 Slp: Restoring the following NT service to a running state after patch action: SQLBrowser2013-08-08 08:16:12 Slp: Sco: Attempting to start service SQLBrowser2013-08-08 08:16:12 Slp: Sco: Attempting to start service SQLBrowser, start parameters 2013-08-08 08:16:12 Slp: Sco: Attempting to start service SQLBrowser2013-08-08 08:16:12 Slp: Sco: Service SQLBrowser already running or pending start2013-08-08 08:16:12 Slp: Sco: Attempting to get service start mode for service SQLWriter2013-08-08 08:16:12 Slp: Invoking QueryServiceConfig Win32 API for buffer size2013-08-08 08:16:12 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer2013-08-08 08:16:12 Slp: Sco: Returning service start mode Automatic2013-08-08 08:16:12 Slp: Sco: Attempting to get service start mode for service SQLWriter2013-08-08 08:16:12 Slp: Invoking QueryServiceConfig Win32 API for buffer sizeI have uploaded both the summary.txt and details.txt file to skydrive at: [b][url=http://sdrv.ms/1cMnPSa]http://sdrv.ms/1cMnPSa[/url][/b]The engine build number of SQL Server was updated and the @@Version displays the correct details: [b]10.50.4000.0[/b].A few hours on google has not brought up anything specific about error code [b]1209309228[/b].Any assistance would be greatly appreciated.

sql server licencing for demonstration purpose

Posted: 07 Aug 2013 06:26 PM PDT

Hi,If I would like to demonstrate my software that runs off sql server 2008 r2 what edition of sql server would I need?If I had multiple demonstrators would I need multiple licences?Documentation on this would be great but ill take any advise.

cluster setup

Posted: 07 Aug 2013 07:06 PM PDT

I have 3 VM servers.I need to setup 3 node cluster using these 3 VM servers.Can someone provide the procedure to setup cluster.Thanks.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog