Re: Attach norecovery database

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 19:49:17 -0400

When you detach a db it rolls back any open trans so the answer is no. You
can attach it but it it will already have been put into recovery. 

-- 
Andrew J. Kelly  SQL MVP
"Kevin" <Kevin@noemail.com> wrote in message
news:OWajj3qmEHA.1288@TK2MSFTNGP10.phx.gbl...
> Is there a way to attach a database to norecovery mode?  We have a 2nd
site
> where the target database is in norecovery mode for continuous log files.
> If we detach the database while it is in norecovery mode, could we attach
> the database back in norecovery mode.  I tried it and it turned into
> recovery mode with few transactions rollback while detach.  Thanks!
>
>
>

Relevant Pages

  • Frequent use of attach and detach
    ... We are considering an architecture in which "detach" and "attach" are used ... We want to have a farm of load servers for a data warehouse. ... database file "F" and loads data. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 location
    ... You can move the data files through a process known as Detach ... Detach the database ... Attach the database ... Real-world stuff I run across with SQL Server: ...
    (microsoft.public.sqlserver.setup)
  • Re: Attach/Detach database
    ... The detach option is context-sensitive so you need to first select the ... You should not create a new database before attaching. ... and copy the files to the new server. ... In the Attach database dialog, ...
    (microsoft.public.sqlserver.programming)
  • Re: Attach/Detach database
    ... The detach option is context-sensitive so you need to first select the ... You should not create a new database before attaching. ... and copy the files to the new server. ... In the Attach database dialog, ...
    (microsoft.public.sqlserver.setup)
  • Re: Attach/Detach database
    ... The detach option is context-sensitive so you need to first select the ... You should not create a new database before attaching. ... and copy the files to the new server. ... In the Attach database dialog, ...
    (microsoft.public.sqlserver.connect)