all groups > sql server data warehouse > december 2003 >
You're in the

sql server data warehouse

group:

Error 927


Error 927 James NO[at]SPAM discussions.microsoft.com
12/31/2003 6:17:25 AM
sql server data warehouse:
I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.

Is this normal or is it safe to assume that is locked up.

What am I missing here.

Thank a million!
Re: Error 927 Vishal Parkar
12/31/2003 11:23:18 PM

hi James,

I guess you have restored the last database backup with "norecovery" option.
Try running following command

restore database <database_name> with recovery


--
- Vishal

[quoted text, click to view]

AddThis Social Bookmark Button