Re: how to restore from file

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jake (rondican_at_hotmail.com)
Date: 04/09/04 

Date: Thu, 8 Apr 2004 21:11:39 -0700

Hari,

    I have done this with a backup from 12/03 and then the one from
yesterday and I get the same errors. The back up done via the db maintenance
schedule and it emails daily that the backup completed successfully so I
don't know why it's not restoring the files it has dumped. Any ideas? Thanks
in advance.

Jake

Errors:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%23LGFudeHEHA.1528@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Since you are going to restore it in same SQL server use the Restore
> database with MOVE option.
>
> Execute the below statement in query analyzer to get Backup file info,
>
> Restore filelistonly from
> disk='driveletter\folder\vcnet_db_200312200700.BAK'
>
> After that you can use any database name to restore the backup file.
Execute
> the below statement to restore the database.
>
> Restore database dbname from
> disk='driveletter\folder\vcnet_db_200312200700.BAK ' with
> stats=10 ,
> move 'logical_datafilename' to 'physical_dataname',
> move 'logical_logfilename' to 'physical_logname'
>
> Note: provide the exact drive letter and folder
>
> Incase if this backup file is not working out, do the same step with other
> backup files, ensure that you disconnect the users connected
> to the database before restore operation using:
>
> Alter database <dbname> set single_user with rollback immediate
>
> Thanks
> Hari
> MCDBA
>
>
>
> "Jake" <rondican@hotmail.com> wrote in message
> news:OjMViFeHEHA.3180@tk2msftngp13.phx.gbl...
> > Hello,
> >
> > We have a file labeled vcnet_db_200312200700.BAK we want to restore
it
> > to a different default database. We somehow lost some data from a table
> and
> > need to restore just the table but we are not sure when we lost it. So
we
> > are wanting to restore the backup database into a temp default created
> > database look for the data and if there import it back to the orginal
> > database. If it doesn't exist we want to restore the next backup
> etc...until
> > we find the data. Any help would be greatly appreciated.
> >
> > Jake
> >
> >
>
>

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)