SQL Server Performance

*_log.mdf

Discussion in 'General DBA Questions' started by boutwater, Oct 22, 2003.

  1. boutwater Member

    I have a server that uses the client tools of SQL to connect to a remote database. I want to copy over the *_log.mdf file without stopping the SQL service. Is there anyway to do this? What does it mean to install another instance of SQL? Thanks for your help,
    Ben
  2. satya Moderator

    Without stopping SQL Services its not possible to touch(copy/move) the .MDF & .LDF files.

    As an alternative use BACKUP/RESTORE method to take copy of this database on the other instance.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. ykchakri New Member

    Or, you can detach the database, copy the .mdf file you want and then re-attach the database.
  4. Luis Martin Moderator

    Detach database is like stopping SQL Services.


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  5. ykchakri New Member

    quote:Originally posted by boutwater

    What does it mean to install another instance of SQL? Thanks for your help,
    Ben

    It means, you can install SQL Server on the same physical server giving a different name for the instance, which creates a completely independent set of binaries and databases. Though it's one physical server you can access and maintain 2 different SQL servers from your client.
  6. ykchakri New Member

    quote:Originally posted by LuisMartin

    Detach database is like stopping SQL Services.


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell

    If you have multiple databases on the same server, stopping services is going to affect all the databases, but detaching is going to affect only that database in question.
  7. satya Moderator

    If you're installing another instance then simple backup/restore is enough.


    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page