471,570 Members | 988 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,570 software developers and data experts.

Filegroup restore problems

Using SQL Server 2000 SP3 I'm developing a data warehouse where data
will be archived off to a filegroup, this filegroup backed up and the
tables in this filegroup truncated to free up space on the server.

So using Enterprise Manager I've copied data to the filegroup tables,
backed up the file group, truncated the tables, but when I have
restored the file group the database is stuck in a state of
'(loading...)' and I can't get it to resume. I've tried running the
command RESTORE LOG databaseName WITH RECOVERY but get an error message
that the database has been restored to different time (sorry I can't
remember exact syntax but I'm not at my work computer)

Is this familiar to anyone? Ignoring the filegroups is there a way I
can get the database .MDF back up and running?

Thanks

Nov 8 '05 #1
2 1892
Hi

From "How to restore files and filegroups over existing files (Enterprise
Manager)" in BOL

Under Recovery completion state, do one of the following:
a.. Click Leave database operational. No additional transaction logs can
be restored if no further transaction log backups are to be applied.
b.. Click Leave database nonoperational, but able to restore additional
transaction logs if another transaction log backup is to be applied
It seems that the log file backup was not taken before the filegroup backup.
If you were not going to restore the logs then the 'Leave database
operational' should be checked.

HTH

John

<si*******@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Using SQL Server 2000 SP3 I'm developing a data warehouse where data
will be archived off to a filegroup, this filegroup backed up and the
tables in this filegroup truncated to free up space on the server.

So using Enterprise Manager I've copied data to the filegroup tables,
backed up the file group, truncated the tables, but when I have
restored the file group the database is stuck in a state of
'(loading...)' and I can't get it to resume. I've tried running the
command RESTORE LOG databaseName WITH RECOVERY but get an error message
that the database has been restored to different time (sorry I can't
remember exact syntax but I'm not at my work computer)

Is this familiar to anyone? Ignoring the filegroups is there a way I
can get the database .MDF back up and running?

Thanks

Nov 23 '05 #2
Hi,

try the command
restore database 'yourdatabase' 'with NORECOVERY

it will then disable loading state ... read restore in BOL with very
carefully theirs a option of norecovery in it , BOL is your friend.

ActiveCrypt
----------------------------
http://www.activecrypt.com

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by newbiegca_sqlsever2000 | last post: by
reply views Thread by Louis | last post: by
reply views Thread by raj.raghavan | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.