Tuesday, June 18, 2013

[SQL 2012] SOS DB In-Recovery

[SQL 2012] SOS DB In-Recovery

SOS DB In-Recovery

Posted: 18 Jun 2013 01:58 AM PDT

I am running SQL Server 2012 on Win 7 machine. Yesterday, due to extended power failure and other issues, the machine froze.Now, when I rebooted the machine, the database is In-Recovery mode.Please help. What do I do?

Cleaning the cache for a Query.

Posted: 17 Jun 2013 10:35 PM PDT

Dear All, While testing a query when we run it second time, it uses cache so performs better then previous run.[b] Do we have any way to clean cache of a particular query without affecting cache of other queries?[/b]

Indexing with Ifilters

Posted: 18 Jun 2013 01:13 AM PDT

I've scoured all the posts on this and followed all the advice and examples and still can't seem to get SQL to index pdfs or office documents so I figure I must be missing something really basic!I have set up a database table for the documents and checked the various filters are installed and enabled (see code below).I know that full text is installed and working as ifI upload a text document via a webpage it indexes fine and a containTable picks up the indexed words. If I do the same with a pdf or word doc then there are no errors, and the fulltext properties say that the document has been added but no index terms appear (using SELECT display_term, column_id, document_count FROM sys.dm_fts_index_keywords (DB_ID('test'), OBJECT_ID('documents'))Any help at all greatly appreciated as I'm losing marbles over this!Ta,Jeff/* code so far*//*not sure of the order some of these statements should appear in but have tried various permutations.. clearly not the right one! */CREATE TABLE [dbo].[Documents]( [ID] INT IDENTITY(1000000,1) , [Extension] [VARCHAR] (10) NOT NULL , [Content] [VARBINARY] (MAX) NOT NULL , [FileSize] [INT] NOT NULL , [FileName] [NVARCHAR] (500) NOT NULL , [Stamp] [TIMESTAMP] NOT NULL )ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOALTER TABLE [dbo].[Documents] WITH NOCHECK ADD CONSTRAINT [PK_Documents] PRIMARY KEY CLUSTERED ([ID])GOExec sp_fulltext_service 'load_os_resources',1Exec sp_fulltext_service 'verify_signature',0EXEC sp_fulltext_service 'update_languages'reconfigure with overrideCREATE FULLTEXT CATALOG testcatalogGOCREATE FULLTEXT INDEX ON [dbo].[Documents]( content TYPE COLUMN extension Language 1033 ) KEY INDEX pk_documents ON testcatalog; GOif (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) <> 1 exec sp_fulltext_database N'enable' GOif not exists (select * from dbo.sysfulltextcatalogs where name = N'Documents') BEGIN SELECT 'Creating new FT Catalogue' exec sp_fulltext_catalog N'Documents', N'create' endGOexec sp_fulltext_table N'[dbo].[Documents]', N'activate' GO/*check adobe filter installedEXEC sp_help_fulltext_system_components 'filter' --pdf and doc filters show up paths correct!!SELECT * from sys.fulltext_document_types*/EXEC sp_fulltext_service 'restart_all_fdhosts' --tried out of desperation - no luck!

AlwaysOn secondary log size

Posted: 17 Jun 2013 09:20 AM PDT

Hi, hoping someone with some experience can help me to decide what to do with the log of an AlwaysOn secondary database.We are backing up the primary database including its log file but the active read only secondary which is used only for reporting has a log that keeps on growing. I can't set the secondary to simple recovery so I can't shrink the log. I don't want to do log backups on the secondary as we are already backing up the primary. I noticed this issue when the log for the secondary filled the entire drive.Is there a solution to this?

SQL2012 crashes

Posted: 17 Jun 2013 09:55 PM PDT

Hi,We have a new MSServer 2012 / MSSQLServer 2012 Enterprise Edition, running under VMWare in a datacenter.Currently we are migrating our customers from the production 2008R2 server.We came across the following: the server crashed with the following event:[quote]Faulting application name: sqlservr.exe, version: 2011.110.3128.0, time stamp: 0x50deadadFaulting module name: myodbc5.dll, version: 5.1.12.0, time stamp: 0x51017fd2Exception code: 0xc0000005Fault offset: 0x0000000000027ad3Faulting process id: 0x398Faulting application start time: 0x01ce56239a757beeFaulting application path: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exeFaulting module path: C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dllReport Id: cb0ad250-d802-11e2-93fc-005056971d36Faulting package full name:Faulting package-relative application ID:[/quote]We use the MyODBC5.dll to connect to a number of MySQL databases. We've been doing this the past few years on our 2008R2 server and a crash never happened. We can even reproduce the crashing by connecting to a MySQL database.Obvious question: what can we do to prevent SQL2012 from crashing? Thanks,Raymond

error configuration of report server on SSMS

Posted: 17 Jun 2013 08:53 PM PDT

hello alli found some troubles when i want to set in the report server on SSMS :ReportmanagerEnabled to ----> TRUEandWebServiceandHTTPaccesssEnabled to ----> TRUEi have this message : this operation could not be completed (Winmgmt ) any help plz ?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog