Post reply

Retrieve databases if the server will not start

  • October 8, 2009 at 11:21 am

    #205427

    Hi all,

    This relates to my previous post, after many, many, many hours of trying valiant suggestions on google, I have decided to give up trying to get my Vista laptop to work for me, permissions-wise.

    Would anyone happen to know how I would go about retrieving databases in from sql server express 2005? My Vista machine has gone doolally and I cannot start the server through the sql server configuration manager.

    I wish to put the databases I worked on, on another PC which is running the full-blown sql server 2005 (not the express version).

    Any ideas?

    With my best

    Mark

  • October 8, 2009 at 11:31 pm

    #1063867

    All SQL Server databases are made up of .mdf and .ldf files. The start of the file name is usually the name of the database. Search you PC for these files. You should be able to copy them to the machine with the working version of SQL and attach them.

    You can attach them by right clicking on the Database node in Management Studio and selecting "Attach...". Follow the boucing ball from there.

  • October 12, 2009 at 10:52 am

    #1064835

    Superb, tried that and got all the data I needed out! Thank you!

Viewing 3 posts - 1 through 2 (of 2 total)

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