Re: Filegroup restore problems

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.downes@xxxxxxxxx> wrote in message
news:1131487927.857991.20510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • Re: PARTIAL SQL Server RESTOREs
    ... DROP DATABASE mywind_part ... ALTER DATABASE mywind ADD FILEGROUP new_customers ... -- A full database backup is performed. ... RESTORE FILELISTONLY lists the database ...
    (microsoft.public.sqlserver.server)
  • PARTIAL SQL Server RESTOREs
    ... Can someone confirm that with a PARTIAL FILEGROUP SQL Server RESTORE you ... have to have a Full Database Backup (containing all the Filegroups including ... Even if you have a performed a filegroup Backup which contains the PRIMARY ...
    (microsoft.public.sqlserver.server)
  • Re: VLDB backups and partial restore
    ... if you do filegroup backups of the ... which is different from doing a 'partial' restore. ... The database cannot be recovered because the files have been restored ... CREATE DATABASE mytest ...
    (microsoft.public.sqlserver.server)
  • Re: Question about restore database and create new filegroups
    ... RESTORE won't help you here, since a restore database will be an image of the source database. ... For a table which doesn't have a clustered index, you just create a clustered on the desired filegroup and then drop that clustered index. ... I want to create separated filegroups and data files to re-organize ...
    (microsoft.public.sqlserver.server)
  • Re: Best way to keep a database clone syncd
    ... though (like reporting can be done off of mirrored or log shipped database). ... We plan to restore a read-only "clone" from our in-house to off-site location ... could we restore hourly transaction logs? ... our production database is SQL Server 2000 and the Web server will ...
    (microsoft.public.sqlserver.server)