Restore incomplete

Karenh

Using SQL Server 2008, we cannot get restore to restore objects (other than tables) and data common to all companies.

I was able to create a company, restore Cronus from backup, and everything worked perfectly.

But not so with the live db. There is no error message, only the usual message about the restore being completed.

I can export/import objects as a workaround but we need to be able to restore objects also.

I have backed up the transaction log, so there is plenty of space there. I am logging in as sa, so permissions are not the problem.

I would appreciate any suggestions.

David_Singleton

Karenh wrote:

Using SQL Server 2008, we cannot get restore to restore objects (other than tables) and data common to all companies.

This means that there are already objects in the database. To do a full restore you need a clean empty database. So start with FILE DATABASE NEW

kine

...I was able to create a company...

If you create company first, the database is not empty anymore, thus you cannot restore objects and data common to all companies...