View Complete Post
I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool
<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of 'xyz_old' does not exi
st in the server with the ID of 'ABCD\Sql_AS', or the user doe
s not have permissions to access the object." Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>
I have tried using different account for impersonation but everything fails.
Any help would be really appreciated.
During logshipping, job on secondary server is ran successfully BUT give this information "Skipping log backup file since load delay period has not expired ...."What is this "Load delay period" ? Can we configure this somehow, somewhere ? NOTE : The value on "Restore Transasction Log tab", Delay Restoring backups at least = Default (zero minutes)Thanks
I know how to take total database backup in SQL server 2008 and SQL Server Management Studio Environment but i failed to take single table backup in database.
It is possible to take single table backup in Oracle using PL/SQL Developer IDE.
Thanks in Advance.....
I'm having a problem with Full-Text Catalog in SQL SERVER 2005.
The problem is: I did a backup of a database that has a full-text catalog from one server and restored on another server.
The restore worked perfectly, but the catalog is down because it is pointing to the physical path from the source server.
To recover this full-text catalog I tried the commands below:
CREATE DATABASE SiteEng2004 ON
(FILENAME = 'D:\SQL SERVER\DADOS\SiteEng2004\SiteEng2004_Data.MDF'),
(FILENAME = 'E:\SQL SERVER\LOGS\SiteEng2004\SiteEng2004_Log.LDF'),
(FILENAME = 'D:\SQL SERVER\DADOS\SiteEng2004\IDX_CATALOG')
Unfortunately it did not work and the following error message occurs :
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "D:\SQL SERVER\DADOS\SiteEng2004". Operating system error 5: "5(error not found)".
Could anyone help me on what I should do to restore this full-text catalog on the destination server ?
Thanks in advance.