SQL Server Performance Forum – Threads Archive
*_log.mdf
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
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
Or, you can detach the database, copy the .mdf file you want and then re-attach the database.
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
quote:Originally posted by boutwater
What does it mean to install another instance of SQL? Thanks for your help,
Ben
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.
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
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.
If you’re installing another instance then simple backup/restore is enough.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>