Rebuildm Error

i use Win AD Server 2000 and SQL server 2000

My Master DB crashed and i run Rebuildm to rebuild
After setting CD-Rom path runing rebuildm

it show error -1
and i check OS event log

17207 :
udopen: Operation system error 5(access deny)during the creation/opening of physical device d:\sqldata\mssql\data\master.mdf

FCB::Open failed: Could not open device d:\sqldata\mssql\data\master.mdf
for virtual device number (VDN) 1.

what's the problem ?

thxOriginally posted by mmmaya
i use Win AD Server 2000 and SQL server 2000

My Master DB crashed and i run Rebuildm to rebuild
After setting CD-Rom path runing rebuildm

it show error -1
and i check OS event log

17207 :
udopen: Operation system error 5(access deny)during the creation/opening of physical device d:\sqldata\mssql\data\master.mdf

FCB::Open failed: Could not open device d:\sqldata\mssql\data\master.mdf
for virtual device number (VDN) 1.

what's the problem ?

thx

rebuildm needs to be able to write to the path that you specified as the source directory. If fails or hangs because it cannot write to your CD-ROM drive. So you'll need to copy the contents of the data directory to a writable device (eg. C:). See http://support.microsoft.com/default.aspx?scid=kb;en-us;273572|||Originally posted by cbatwillis
rebuildm needs to be able to write to the path that you specified as the source directory. If fails or hangs because it cannot write to your CD-ROM drive. So you'll need to copy the contents of the data directory to a writable device (eg. C:). See http://support.microsoft.com/default.aspx?scid=kb;en-us;273572

Yes!! It's problem with Read-Only !
thank you ^_^

Rebuilding SQL2000 analysis services after server crash and attaching the Cubes

Hi,

The SQL2000 database server got crashed and has to be rebuilt from the scratch. The OS and SQL2000 Database and Analysis Services go reinstalled and luckily the data files residing on the SAN is intact and we were able to reattach the SQL databases.

The question is how can I reattach the OLAP databases and cubes. Apparently we currently do not have backups of OLAP databases but the OLAP data directory on SAN is available and is intact.

So Is it possible to reattach the OLAP database and cubes just like the way we attach the SQL databases.

Please let me know how we can fix the issue at the moment since this is a production issue.

Thanks

Vish

In Analysis Services 2000 all the informations about cubes and dimension structures are stored in the metadata repository db.

The metadata repository db, by default, is an Access db (msmdrep.mdb) that you can migrate to a SQL Server db using Analysis Manager (right click on the server and choose migrate repository).

So if you now have "that" metadata repository (the one before the crash) you can use it and AS can recognise the structure in your OLAP data directory but if you don't ... I don't know a solution to your problem.

Do you really don't have any backup of your production OLAP db?

Francesco