Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-10-21 : 16:12:29
|
| I am having a problem creating a bacup of a databse, currently using sql 2005.this database was created using 2000 and recebtly switched to 2005, before we used to create backup using 2000 without any problem, but now using 2005 getting error:I searched on net got this info from Microsoft: but don't know how to do please any tips would really help me:**************************************************************http://support.microsoft.com/kb/923355/en-usWORKAROUNDTo work around this behavior, follow these steps:1. Locate the folder that contains the files for the problematic full-text catalog. 2. Run the ALTER DATABASE statement. Specify in the statement the correct location for the full-text catalog.For more information about how to use the ALTER DATABASE statement in this scenario, visit the following Microsoft Developer Network (MSDN) Web site, and then search for the "Moving Full-Text Catalogs" topic: http://msdn2.microsoft.com/en-us/library/ms345483.aspx (http://msdn2.microsoft.com/en-us/library/ms345483.aspx) 3. Rebuild the problematic full-text catalog in the database. 4. Perform a full backup of the database in SQL Server 2005 again. **********************************************************Thank you very much for the information. |
|
|
|
|
|
Rebuild the problematic full-text catalog in DB