Re: 2nd Try: Restore Database Dialog missing Backups (Archive BIT)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 13:40:38 -0400

Interesting problem indeed -- can you use the "native" T-SQL RESTORE to
perform the database restore?

Steve

"Doug Crabtree" <not@gonna.tell> wrote in message
news:np-dnVZYZaxf9b7cRVn-ig@comcast.com...
> In Enterprise Manager, Right click on Databases, and select All Tasks ->
> Restore Database...
>
> "Restore Database" Dialog Box
> Restore as database: <<DBNAME>>
> From Device selected
> Restore backup set (Database - complete) selected
> Click Select Devices button
>
> "Choose Restore Devices" Dialog Box
> Disk selected
> Click Add button
>
> "Choose Restore Destination" dialog box:
> File Name (click the ...)
>
> "Backup Device Location - <<SERVERNAME>>" Dialog box:
> They don't show.
> -------------------------------------------------------------------------- 

--
> -------------------
> Interesting, though ... I copied one of the backups to another disk,
turned
> off the archive bit, and it showed there.  Something about that drive?
> Permissions?  We have the Server running as an administrator's account.
> Would that have anything to do with it?
>
> Thanks,
> Doug
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
in
> message news:OtgmcOShEHA.1156@TK2MSFTNGP10.phx.gbl...
> > Strange indeed. Can you point me to exactly what dialog you refer to
(how
> to you "click" to get
> > there) and I'll give it a spin. I've never encountered this, or even
> thought about the archive bit
> > being relevant...
> >
> > -- 
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
>
>

Relevant Pages

  • Re: 2nd Try: Restore Database Dialog missing Backups (Archive BIT)
    ... Interesting problem indeed -- can you use the "native" T-SQL RESTORE to ... perform the database restore? ... Steve ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: 2nd Try: Restore Database Dialog missing Backups (Archive BIT)
    ... Interesting problem indeed -- can you use the "native" T-SQL RESTORE to ... perform the database restore? ... Steve ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Re: A Question on Database Restore
    ... Try entering the UNC name of the shared drive and backup file directly in ... (for a full database restore). ... > I have a question on database restore in SQL server 2000. ... > I would like to restore a BAK file which is stored in another server. ...
    (microsoft.public.sqlserver.server)
  • Re: Restore log failed SQL 7
    ... FULL DATABASE RESTORE using a full backup file. ... After this apply the transaction log ...
    (microsoft.public.sqlserver.server)
  • Re: Ok, so Im a lazy moron - Explorer crashes at startup
    ... But it's easier to Create a restore then use Disk Cleanup to remove all but the last. ... >> Steve Nielsen wrote: ... >>>>I did post over in the tablet pc group, not as busy as here so no ... >> Administrator, clear out all the System Restore backups, then disable System ...
    (microsoft.public.windowsxp.general)