Full Textx Error
Mar 28, 2008
hi
this follwoing code is throwing an error in sql server 2005
CREATE FULLTEXT INDEX ON table_name
[(column_name [TYPE COLUMN type_column_name]
[LANGUAGE language_term] [,...n])]
KEY INDEX index_name
[ON fulltext_catalog_name]
[WITH
{CHANGE_TRACKING {MANUAL | AUTO | OFF [, NO POPULATION]}}
]
the error is as follows :
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'FULLTEXT'.
what is wrong with the syntax?
thanks in advance
View 4 Replies
ADVERTISEMENT
Jan 22, 1999
I am trying to load 200,000 records into a MS SQL 6.5 database table using a Visual Basic data load program. I continuously receive the following error message after 175,000 records.
[Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object 'Syslogs' in database 'ECAPDemo' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment. Occurred on 01/22/1999 03:35:41 pm
ODBC--call failed. Occurred on 01/22/1999 03:35:41 pm
I increased the Master database size up to 200 Mb, with TempDb at 250 Mb but I still receive the error.
Any suggestions?
View 2 Replies
View Related
May 22, 2004
Hello,
I have a process that failed with the following error message. The SQL server error messages also said the Transaction log was full and there was not enough disc space.
Strangely, when I checked all the drives on the server, there was plenty of free space, the smallest amount free on one drive, where SQL server is located was 20GB. I am confused.
I backed up the DB to another server and deleted a lot of the transaction logs and now the drive has 30GB and is okay.
Does anyone know how the transaction log fills up? Can I change a setting somewhere to increase the maximum size of the transaction log? Or maybe change the location where it is saved to another drive? Or have it automatically cleared out every once in a while?
Any of your input is greatly appreciated.
Thanks.
Rodney
--------------------------------------------------------------------------
DS-DBMS-E400: UDA driver reported the following on connection 'Data Target
(ODBC)':
DMS-E-DBPARSER, The underlying database detected an error during processing of
the SQL request.
[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database
'ancosalesdm' is full. Back up the transaction log for the database to free up
some log space.
(for details, see Build_SAL_FA_ShipSKU_0584.log)
[PROGRESS - 00:32:42] Build Node 68 'SAL_FA_ShipSKU'; failed
DS-DBMS-E400: UDA driver reported the following on connection 'ALIAS_00DF1E74':
DMS-E-GENERAL, A general exception has occurred during operation 'execute
immediate'.
The log file for database 'ancosalesdm' is full. Back up the transaction log
for the database to free up some log space.
DMS-E-GENERAL, A general exception has occurred during operation 'execute
immediate'.
General SQL Server error: Check messages from the SQL Server.
DS-DBMS-E400: UDA driver reported the following on connection 'ALIAS_00DF1E74':
DMS-E-GENERAL, A general exception has occurred during operation 'rollback
transaction'.
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
DMS-E-GENERAL, A general exception has occurred during operation 'rollback
transaction'.
General SQL Server error: Check messages from the SQL Server.
--------------------------------------------------------------------------
View 4 Replies
View Related
Apr 4, 2008
Trying to make a full-text table of a few tables in SQL server 2000 using the SQL Server Managment Studio. I am getting the following error when I then try to view the columns using the table. The column it is having a problem with is just a varchar text column. I have tried a few different tables and each time it has a problem with one of the columns. It does not give me an error when creating the full-text table. Anyone have any information on this?
I check on a full text table I made a while ago and it is giving me the same error but searches on it seem to be working, but cannot tell if it is using the one column it is having an issue with.
Property TypeColumnName is not available for FullTextIndexColumn '[MyColumnName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
View 2 Replies
View Related
Jul 16, 2001
Hey guys,
I'm exporting via dts to an excel spreadsheet. However my database has more than 65000 records. DTS croacks and shoots out that there are too many records in the spreadsheet.
What do I do? Any way to go around that? These are my daily hit logs that are recorded and they tend to get big.
Ilya Zherebetskiy
View 1 Replies
View Related
Aug 19, 2002
I am running a copy object DTS and consistently get the error 'cannot allocate space for <objectname> because the primary filegroup is full.
I've got auto-grow on with unliminted growth. There is more than enough space on our Data and Log file disks. I haven't reached teh 32TB limit of the filegroup size by any stretch of the imagination. The source datbase is 250mb yet even when I create the destination DB at 300mb I still get the error!
Also, I tried creating a secondary filegroup and this didn't help, either.
Any suggestions would be appreciated.
Colleen
View 1 Replies
View Related
Jun 26, 2001
Hey - this is a SQL 6.5 Question. I get an error that goes something like this...
Can't allocate space for object 'Syslogs' in database 'test_database' because the 'logsegment' segment is full. If you ran out of space in the Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size fo the segment.
Okay, i understand that the log is full. But since I have been working mainly on SQL 7, I don't completely understand the 'dumping'. I know that everyone is busy, and if you don't have time to explain this to me, could you tell me where to look? I am going to check MS Knowledge Base, but any advice or direction is appreciated.
Thanks guys and gals!!!
View 2 Replies
View Related
Oct 19, 2005
Could not allocate space for object 'dw_MasterClaim_ProcLine' in database 'fl1stDwProd2' because the 'PRIMARY' filegroup is full..
I have two db's prod1 and prod2.
I looked at the properties of each.
On the tab Data Files both of these have the same file name (prod2).
One has 5897 space allocated and the other 13162.
Not sure why they are like this or even if it's correct. Could this be my problem? If so, how can I fix?
View 2 Replies
View Related
Feb 9, 2008
I have just added a 500G USB drive. I have created a DB on it and am attempting to export data to it. The problem is I keep getting:
Could not allocate space for object 'dbo.Matched' in database 'MyDBK' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup
The drive is empty so there is plenty of room. How do I set auto gro or something so this error goes away?
View 9 Replies
View Related
Jul 20, 2005
Dear SirI have problem which I am describing below:-In my databse , size of Data file is 40 MBsize of Log file is 4158 MBwhich is causing the size of my database so hugewhy this log file is so huge ?How I can control it, I have already set Parameter for Data and Log filei.eUnrestricted Growth and Grow Automatically 10-PercentI want to control Log file Size.Regard'sVineet Bisht*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies
View Related
Feb 16, 2007
I'm using Full-text in various databases on my servers (SQL2005 on W2K3). On a few databases the Full-text population ends with the error:
'Error '0x80030050' occurred during full-text index population for table or indexed view '[database].[dbo].[table]' (table or indexed view ID '1714105147', database ID '9'), full-text key value 0x00015EE1. Failed to index the row.'
The next log-line lets me know the name of the dll that caused the problem:
The component 'offfilt.dll' reported error while indexing. Component path 'C:WINDOWSsystem32offfilt.dll'.
There's one solution I read about, but that one is not the case here. That sollution states that this problem occurs when de datatype is not the same as the filetype (e.g. datatype is pdf, documenttype is doc).
What can be the problem here?
Thanks.
View 5 Replies
View Related
Feb 11, 2008
Hi,
I build some t-sql code to check if full text is installed on the sql server. If not, some sql statements must be not executed. Here is my code:
if (select serverproperty('IsFullTextInstalled')) = 1
Begin
EXEC sp_fulltext_database 'enable'
CREATE FULLTEXT CATALOG [...] WITH ACCENT_SENSITIVITY = OFF AS DEFAULT
CREATE FULLTEXT INDEX ON dbo.Test (Name LANGUAGE 0, Description LANGUAGE 0) KEY INDEX IX_Test_1 ON [...] WITH CHANGE_TRACKING AUTO
ALTER FULLTEXT INDEX ON dbo.Test ENABLE
End
Statement 1 and 2 is not executed, but for statement 3 the server throws the following error:
Full-Text Search is not installed, or a full-text component cannot be loaded.
I don't know why the server tries to execute statement 3, because it is in an if statement.
Any help is welcome.
View 10 Replies
View Related
Jul 27, 2001
I am pulling my hair out trying to resolve this issue. I have placed several messages on different message boards and have not received any response to this issue. Can anyone here please help me?
I have installed 'full text index' on a server, initialized it and created a job to full text two fields in a table. I can see that the last refresh was a day ago. I am calling a stored procedure: (the server is version 7 of SQL Server with sp3)
CREATE PROCEDURE [SearchFaq]
@pSearchString varchar(200)
AS
SELECTfaqID, FaqQuestion, FaqText, Status, InputDate
FROMfaqs
WHEREContains(*, @pSearchString) and Status = 1
All I get is this error message, whether I call this from an asp page or run it directly from query analyzer:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Search on full-text catalog 'etr_fts' for database ID 10, table ID 1429580131 with search condition 'faq' failed with unknown result (324bd27c).
Please HELP!!
View 3 Replies
View Related
Apr 5, 2000
Hi,
I am just starting to study for the sql 7.0 admin test. Using the sybex book and bol I have run accross an error that I can not seem to find any support for. I am trying to do a full text index and I receive the following area: "An unknown full text failure (80004005)occured in function EnumCatalog on full text catalog".
I have looked on the website high and low and cant find anything on this error. Can someone give me some possible input to what the problem is?
thanks,
Jerry
jarnone@bellsouth.net
View 2 Replies
View Related
Dec 2, 2004
(SQL SERVER 2000)
I keep getting the "primary filegroup is full" error when ever I try to write data even though the following things are true:
allow unlimited growth set for BOTH database and transaction log
auto shrink and auto update statistics flags are set in database options
growth set to 10 percent for both
database is 4GB but disk has 12GB freespace
transaction log is on same disk but is only 8MB ???
SQL shows the database has 2% free space but any attempts to write cause the error, shrinking drops this to 1% but still produces the same error on writes
SQL shows the transaction log has 90% free space
backup maintenance plans are in operation for both transaction log and database (write to different drive)
I am completely confused!
View 5 Replies
View Related
Jan 26, 2004
I am using 6.5 .
Here is the error that i get
Think that tempdb is small how do i change that or what is this error about'
--------------------------
AIMSMan
---------------------------
Application-defined or object-defined error 40002
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object '##RevByNetSALIMJUMMA' in database 'tempdb' because the 'default' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.( 1105)
ODBC
I only have data and log device how do i increase the tempdb device
let me know
SEJ
View 4 Replies
View Related
May 22, 2008
Can anyone help please?
I am getting the following error:
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'dbo.SORT temporary run storage: 162781324115968' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Msg 9002, Level 17, State 4, Line 1
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Regards,
Krishna
*Learning IT from experience*
View 4 Replies
View Related
Jul 23, 2005
Does anyone know exactly what behaviour is exhibited when running astored procedure and the log file fills up while the procedure is stillrunning?I am seeing, through a created history table, a stored procedure thatbegan to run (by the fact that there is a row in the history table) butnot finish correctly. It is being called by VB and no user isreporting that VB is erroring out.Checking some of the SQL log files, the times the SQL proc bombed isaround the same time the SQL transaction log had to be manually dumpedbecause it was full.Thanks,
View 1 Replies
View Related
Feb 9, 2007
"The log file for database is full. Back up the transaction log forthe database to free up some log space."Now I only know this way to deal with that manually,Step1. in option , chance Recovery model from FULL to Simple.Step2: go to task to manually shrink the log fileStep3: Change recovery model back from simple to FULL.But by this way, I could get same problem again, the log file is fill,and need free up.Could you give an idea how to prevent this from happening? what andhow should I do???Thanks a lot in advance for your help.
View 3 Replies
View Related
Jul 20, 2005
I keep getting the following error message when I run a serie of SQLcommands:Server: Msg 9002, Level 17, State 6, Line 15The log file for database 'tempdb' is full.Back up the transaction log for the databaseto free up some log space.I have tried "dump transaction tempdb with no_log" right before I runthe SQL command. But that doesn't help.The serie of SQL commands that I try to run is the following:create table #NewBatOp(BatchJournalID uniqueidentifier not null,batch_nr varchar(5) null,OperationNum varchar(3) null,OperationHours real null,EmployeeNum varchar(6) null,OperationDate datetime null,IsOverTime tinyint null)-- |-- Comment this one line-- | out will not triggerinsert into #NewBatOp -- <---| the errorselectbj.BatchJournalID, bj.batch_nr, bo.opno,bo.hrs, bo.bonno, bo.dat, bo.otflgfrom batop boinner join BatchJournal bj onbo.bat = bj.batch_nr andbj.BatchJournalID in(select BatchJournalID from BatchControl)if ( @@error <> 0 )goto OnErrordrop table #NewBatOpgoto EndTestOnError:drop table #NewBatOpprint "Error: Failed to import new batch-operations intojournal."EndTest:I have tried running the above statements in ISQL and in QueryAnalyzer, and I get the same error.I didn't have this problem before I have moved the database from oneserver to another server.- The OS in the old server is Windows-NT,and the SQL Server in the old server is the 2000 version.- The OS in the new server is Windows-2000,and the SQL Server in the old server is the 2000 version.The settings in tempdb in both servers are more or less the same.Actually, the tempdb in the new server is actually much bigger thanthe one in the old server. The size of the transaction logs in bothserver are the same (and cannot be changed manually). Both the dataand the transaction log of tempdb can automatically grow in 10%increment and no restriction on size.The data-and-log of the tempdb are both in one hard disk. The harddisk has 10-GB free space available. Moreover the size of the resultset from the "select" statement above is only 530KB (around 3000 rowsin the result-set). I believe it is a very small database operation.Therefore, I don't think the size has anything to do with the error.I don't think the "inner-join" clause is the cause of the problem. Thereason is that I have used the same "inner-join" clause in otherqueries, and they don't have any problem. As a matter of fact, I haveused many other queries that are far more complicated and have createdmuch bigger result set in tempdb, and they don't have this problem.I am very puzzled of this error. Can someone give me a pointer?Thanks in advance for any info.Jay Chan
View 10 Replies
View Related
May 15, 2007
Hello everybody,
I have installed SQLServer 2005 for take advantage of full text seach features.
When I start full population, there are some rows that cause error and not are indexed.
I see the log in C:ProgrammiMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLFT0000700005.LOG. In this file there are seven rows that have error and for everyone a line that say:
"Error '0x8004fd01: The IFilter::Init() function call failed.' ... full-text key value 0x495532303045594154504B55. Attempt will be made to reindex it. The component 'pdffilt.dll' reported error while indexing. Component path 'C:ProgrammiFoxit SoftwareFoxit PDF IFilterpdffilt.dll'."
With different full-text key value for every line.
My question is:
1) Start from a full-text key (ie. 0x495532303045594154504B55), how I arrive to the record in the source table for understand which is the problem?Otherwise how can I examine the problem if I don't know the row that cause the error?
2) What is the error 0x8004fd01?
3) Could be that the PDF filter of Foxit is better than Adobe? With Adobe filter (version 6) my full pupulation is endless!
Thanks!
View 1 Replies
View Related
Nov 20, 2000
Hi all,
I need to load a table with 820,000 records from a Sybase db via DTS. It always fail with the error:
"Error at destination for row number 820000. Could not allocate space for object in tablespace tempdb
. The default filegroup is full.".
There is only the primary filegroup defined in the db. I've increased the size from 1.5GB to 2GB,
and specify that it shd grow automatically by 10% and there's no limit to the size.
There is still some 28GB in the server, so it should be fine.
It still fail so I added another file to the primary filegroup with size 100MB. Again, it failed with the same error msg.
Where or how else can I increase the tempdb size?
Any help is appreciated.
Thanx,
Jes
View 1 Replies
View Related
Jan 31, 2008
I have an error on the phpbb message board I am using. I have a MS SQL database and cannot figure out what I get this error. How could I fix this?
The full error is:
Could not allocate space for object 'phpbb_topics' in database 'adultsiblinggrief' because the 'PRIMARY' filegroup is full.
View 1 Replies
View Related
Mar 26, 2007
Hi guys, I sent the following queries to my DB and they seem to work with success messages after each line but when I try to test it I get the message at the bottom. Any ideas? there's a good chance my test sql is all wrong!
sp_fulltext_database 'enable'
sp_fulltext_catalog 'Fulltextcatalog1','create'
sp_fulltext_table 'test','create','Fulltextcatalog1','PK_test'
sp_fulltext_column 'test','text','add'
sp_fulltext_table 'test','activate'
sp_fulltext_table 'test','start_full'
sp_fulltext_table test, 'Start_change_tracking'
sp_fulltext_table test, 'Start_background_updateindex'
---- now test it ---
SELECT * FROM test WHERE FREETEXT(*,'spotless')
gets this result:
Error -2147217900
Execution of a full-text operation failed. The catalog does not exist or is currently unavailable. Please retry the action again later and if this symptom persists, contact the system administrator.
View 1 Replies
View Related
Dec 19, 2006
Hi, though i've been using sql server 2000 developer edition for awhile, I guess i overlooked the fact that the full-text search tool was never installed and i never needed it until now. Anyway, tried installing it today and get this error:
Installation of Microsoft Full-Text Search Engine Package Failed (-2147220991) 0x80040201
An event was unable to invoke any of the subsribers
I have no idea what this means - can you help me to get this installed correctly? I did just install service pack 4, and i tried reinstalling the components, tried rebuilding the registery of the current instance, and even tried creating a new instance with hopes that the new instance would install the full-text component - which it did not.
Any suggestions? Maybe I have to unistall the entire Software and reinstall it? Would I lose any of my data in doing this? I should note that all other tools seem to function fine.
Thanks ahead!
Dan
View 1 Replies
View Related
Jul 23, 2005
has anyone met with this before?the setting is SQL2K with SP3 on a 2 node active-active W2K3 cluster.on one of the machine, it occasionally prompts for the following error:"The log file for database "tempdb" is full. Back up the transactionlog for the database to free up some log space."the problem is, at the time of error, the tempdb tx log is only 200MBand there are over 50G disk space available.settings of tempdb:-- 10% autogrow, unlimited max size-- auto shrink off-- data file around 1GThanks.
View 3 Replies
View Related
Sep 13, 2006
I am running the following script to attempt a restore of a differential backup:
RESTORE DATABASE AdventureWorks
FROM DISK='C:SQL2005_BackupsAutoBackupsAdventureWorks.bak'
WITH
NORECOVERY
GO
RESTORE DATABASE AdventureWorks
FROM DISK='C:SQL2005_BackupsAutoBackupsAdventureWorksDiff.bak'
WITH RECOVERY
GO
I thought this was the way to do it. It does restore the full backup, but on the attempt to restore the differential backup, I get the following error:
Msg 3136, Level 16, State 1, Line 1
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Does anyone know what this means? Do I have to use "with recovery" on the first restore? (The sample I took this from used "with norecovery")
The original backups were done with SQL Agent scheduled jobs. The script for the full backup is:
BACKUP DATABASE AdventureWorks
TO DISK='C:SQL2005_BackupsAutoBackupsAdventureWorks.bak'
The script for the differential backup is:
BACKUP DATABASE AdventureWorks
TO DISK='C:SQL2005_BackupsAutoBackupsAdventureWorksDiff.bak'
WITH DIFFERENTIAL, INIT
All I can say is, it's a good thing I am testing this out with non-critical data, because I obviously don't know what I am doing. (Sorry, I'm primarily a programmer, not a DBA) Can anyone help?
Thanks
View 4 Replies
View Related
Oct 28, 2015
We have an iFilter to extract text on emails and their attached files. I have encountered 5 emails that receive the following error code, but I cannot find anything on the error code: Error '0x80fc7586' occurred during full-text index population for table or indexed view '[RIA_Unindexed].[dbo].[Emails]' (table or indexed view ID '485576768', database ID '31'), full-text key value 'E11264A2-A17D-E511-80E0-005056B240B1'. Attempt will be made to reindex it.After a number of retry attempts they will fail to index.what does error code '0x80fc7586' refer to, I have not found it.
Since the first two bytes of the error code are the severity and facility reporting the error, I stripped off that information and looked for error 0x7586 or 30086. That error reported "Too Many products".Theses emails being indexed contain attachments with large attachments that then the attachment chunks are being called for from the fdhost may result in too many chunk segments, or more likely there are some repeating words in the extracts like 4 million occurrences so right now I am testing that condition. To see if the word breaker is throwing the error.
View 10 Replies
View Related
Dec 20, 2006
Hi, though i've been using sql server 2000 developer edition for awhile, I guess i overlooked the fact that the full-text search tool was never installed and i never needed it until now. Anyway, tried installing it today and get this error:
Installation of Microsoft Full-Text Search Engine Package Failed (-2147220991) 0x80040201
An event was unable to invoke any of the subsribers
I have no idea what this means - can you help me to get this installed correctly? I did just install service pack 4, and i tried reinstalling the components, tried rebuilding the registery of the current instance, and even tried creating a new instance with hopes that the new instance would install the full-text component - which it did not.
Any suggestions? I just completely uninstalled sql2000 and did a full-reinstallation and still it wont let me install the full-text search engine component - i check the checkbox in the installation wizard and then it gives me the same error as above.
Thanks ahead!
Dan
View 6 Replies
View Related
Apr 9, 2007
Hello,
I've enabled full-text indexing on one of my tables, and the following query used to work:
SELECT *
FROM TempAttachment
WHERE CONTAINS(attachment, 'text')
However, now I get the following error:
Msg 9955, Level 16, State 1, Line 1
SQL server failed to communicate with Full-Text Service (msftesql). The system administrator must make sure that same service account is used for both services and the service account has the permission to auto start the full-text service.
I've checked the configuration and verified that both accounts are the same. I've restarted the services, and tried rebooting, and still no luck. I did a search on this error, and found this page from MSDN, which doesn't help me much: http://msdn2.microsoft.com/en-us/library/aa337365.aspx.
Has anybody come across this before? Any help would be greatly appreciated!
View 3 Replies
View Related
Jul 17, 2015
I am altering a table ( changing the data type to varchar (8000) from nvarchar (1500) ) with 352929 rows. I get the transaction log full error.
The database is in FULL RECOVERY model. I changed the recovery model to SIMPLE and performed the alter but I still run into error.
View 3 Replies
View Related
Jul 23, 2015
I have a database that has had a full text index at some point in it's history - but no longer does. The database is currently at SQL 2012 compatibility, but it was created on SQL2000. It still appears to have a row in the internal table sys.sysftinds - but some of the column values are NULL, and NULLs are not allowed. The database fails DBCC checks because of this.
Msg 8970, Level 16, State 1, Line 2
Row error: Object ID 25, index ID 1, partition ID xxxx,
alloc unit ID xxxx (type In-row data),
page ID (1:xxxx), row ID 0. Column 'sensitivity' was created NOT NULL, but is NULL in the row.
DBCC results for 'sys.sysftinds'.
There are 1 rows in 1 pages for object "sys.sysftinds".
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sys.sysftinds' (object ID 25).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (xxxx.sys.sysftinds).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Running DBCC with repair_allow_data_loss has not worked.
View 6 Replies
View Related
Nov 15, 2006
I have two instances (Source and Destination) on the same server, i did a full backup of a database on the source server, i did a restore on the destination using the NORECOVERY mode, now the database on the destination as green arrow saying "restoring". From the source database i set up the mirroring, i'm using port 5022 on source and 5023 on destination, everything seems to connect fine but when i start mirroring i get the error message "Database mirroring cannot be enabled because the database is not full recovery error: 1465" but when i look at the property of the db on the source the recovery model shows full as so the destination?
View 1 Replies
View Related
