dbTalk Databases Forums  

Bug in BackUP/Restore procedures

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Bug in BackUP/Restore procedures in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tim
 
Posts: n/a

Default Bug in BackUP/Restore procedures - 04-18-2006 , 02:54 PM






Hi,
Looks like this is a bug. I try to Backup ABC databse and Restore database
with New Name - ABC_NEW.
Below is my script:

<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>ABC</DatabaseID>
</Object>
<File>ABC.abf</File>
<AllowOverwrite>true</AllowOverwrite>
</Backup>

Command executed Successfully

<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<File>D:\Backup\ABC.abf</File>
<DatabaseName>ABC_NEW</DatabaseName>
<AllowOverwrite>true</AllowOverwrite>
<Security>IgnoreSecurity</Security>
</Restore>

Command executed Successfully

After Restore I get new database ABC_New with all dimensions in place, but
instead of cell #VALUE!.
Error message:
File system error. The following file is corupted. Phisycal file -
F:\...\36.fact.data Logical file.

If I replace this file which is about 2.5 GB from original database it work
fine.
Is it bug or I am doing something wrong.
Please advice.
Tim.


Reply With Quote
  #2  
Old   
Edward Melomed [MSFT]
 
Posts: n/a

Default Re: Bug in BackUP/Restore procedures - 04-19-2006 , 10:05 AM






If you can consistently reproduce the problem, please file a case with
Customer Support for it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights



"Tim" <Tim (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
Looks like this is a bug. I try to Backup ABC databse and Restore
database
with New Name - ABC_NEW.
Below is my script:

Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
Object
DatabaseID>ABC</DatabaseID
/Object
File>ABC.abf</File
AllowOverwrite>true</AllowOverwrite
/Backup

Command executed Successfully

Restore
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
File>D:\Backup\ABC.abf</File
DatabaseName>ABC_NEW</DatabaseName
AllowOverwrite>true</AllowOverwrite
Security>IgnoreSecurity</Security
/Restore

Command executed Successfully

After Restore I get new database ABC_New with all dimensions in place, but
instead of cell #VALUE!.
Error message:
File system error. The following file is corupted. Phisycal file -
F:\...\36.fact.data Logical file.

If I replace this file which is about 2.5 GB from original database it
work
fine.
Is it bug or I am doing something wrong.
Please advice.
Tim.




Reply With Quote
  #3  
Old   
Tim
 
Posts: n/a

Default Re: Bug in BackUP/Restore procedures - 04-19-2006 , 01:01 PM



Thank you Edward. We are going to create ticket with Microsoft.

"Edward Melomed [MSFT]" wrote:

Quote:
If you can consistently reproduce the problem, please file a case with
Customer Support for it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights



"Tim" <Tim (AT) discussions (DOT) microsoft.com> wrote in message
news:669BCAD4-9FD5-4D48-9969-5001DF237D0D (AT) microsoft (DOT) com...
Hi,
Looks like this is a bug. I try to Backup ABC databse and Restore
database
with New Name - ABC_NEW.
Below is my script:

Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
Object
DatabaseID>ABC</DatabaseID
/Object
File>ABC.abf</File
AllowOverwrite>true</AllowOverwrite
/Backup

Command executed Successfully

Restore
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
File>D:\Backup\ABC.abf</File
DatabaseName>ABC_NEW</DatabaseName
AllowOverwrite>true</AllowOverwrite
Security>IgnoreSecurity</Security
/Restore

Command executed Successfully

After Restore I get new database ABC_New with all dimensions in place, but
instead of cell #VALUE!.
Error message:
File system error. The following file is corupted. Phisycal file -
F:\...\36.fact.data Logical file.

If I replace this file which is about 2.5 GB from original database it
work
fine.
Is it bug or I am doing something wrong.
Please advice.
Tim.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.