all groups > sql server (alternate) > january 2004 >
You're in the

sql server (alternate)

group:

Cognos IWR Server


Cognos IWR Server Bliss
1/21/2004 4:22:23 PM
sql server (alternate):
Our disk drive died, and we were able to backup most of the files (all
the reports, the shuttled, pending, etc)

But when we open the administrator, we get a blank. none of our
catalogues are listed in there.

I don't want to recreate all the catalogues and reports- does anyone
know how we can "import" them in there? The database that contains all
the "data" was not backed up, sicne it was in use during backup (bad
Network admin)

If anyone can help, PLEASE email. trying to get an answer from cognos,
but who knows?!!!
Re: Cognos IWR Server sql NO[at]SPAM hayes.ch
1/22/2004 1:01:18 AM
[quoted text, click to view]

I have no idea about the Cognos side of things, but if still have the
..mdf and .ldf files for your MSSQL databases, you can try using
sp_attach_db or sp_attach_single_file_db to attach them again. If this
doesn't work, and you have no backups, then all you can really do is
contact Microsoft PSS. They may be able to help recover data from the
files.

By the way, MSSQL databases can be backed up while in use - this is
usually how backups are done.

Re: Cognos IWR Server Bliss
1/22/2004 11:03:31 AM
Thanks! But Cognos, apparently (to the dismay of the network admin) was
skipping open files.

And we have all the reports/databases. We were more interested in the
cogno's side of things. We can't import into the admin program.

But thanks for the info!

[quoted text, click to view]
AddThis Social Bookmark Button