Post reply

How to copy SQL Server primary data file and log file, please help

  • October 26, 2009 at 6:28 pm

    #211460

    hi All,

    I am unable to start the SSMS the error i get is "The type initializer for 'AsyncWmiBinding' threw an exception. Additional information: unable to load DLL 'sqltoolsvsnativehelpers.dll' access is denied.

    I want to copy the database in the sql server without connecting to SSMS. Is that possible.

    Please help i don't have a latest back up of the databases in the server, so i i can copy the primary data and log file directly from the D://program Files/Microsoft SQL Server/MSSQL/Data folder, can i use those to restore the database?

    Please help me, the SQL Server 2005 is installed on Microsoft Windows Server 2003 operating system, my IT guys suspect there is a virus in the system and want to wipe everything.

    But i want to copy the databases in the server before they do that. Any suggestions will be highly appreciated.

    Thanks, Shilpa.

  • October 26, 2009 at 11:26 pm

    #1071025

    First of all don't panic. Cool down. There are many experienced SQL experts here in this forum. They will give you a proper solution.

    I think you can stop SQL Server from windows services.

    and keep a backup of MDF and LDF files. Since SSMS is not opening you can try reinstalling the same once the virus is removed. It might work as usual then. It's just my opinion. Other might guid you properly.

    By the way, why there's no backups.?

    Your data is not that important and you can afford data loss.?

    Make a proper DR plan today itself.

  • October 26, 2009 at 11:42 pm

    #1071031

    Hi

    You will have to stop SQL Server service. You can do that from Control panel\Administrative Tools\Services. Then you can copy the mdf and ldf files to another db server and attach them.

    Make sure that you scan the mdf and ldf files, you dont want the new server to be infected.

    "Keep Trying"

  • November 10, 2009 at 2:25 pm

    #1077531

    hi,

    Sorry for the late reply and i really appreciate your time and advice. I have done as adviced and it worked. The database on my laptop is testing database which i use and didnt bother to set up backups but now i have got my lesson.

    Thanks, Shilpa.

  • November 10, 2009 at 2:26 pm

    #1077532

    hi Chirag,

    Thanks for your advice i have used that. I really appreciate your time.

    Thanks, Shilpa.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply