Post reply

Attaching DB Question

  • February 12, 2013 at 6:59 am

    #274049

    I am trying to set up AdventureWorksDW2008R2 on a test server at work. I have created the DB(on a network server) now I want to attach the mdf/ldf files which I have on my workstation. When I attemp to attach from SSMS on my workstation, I can't navigate to my workstation file structure to point to the MDF file. I can only see the server file structure. Is there a way arround this? Perhaps a command I can run?

  • February 12, 2013 at 7:05 am

    #1586994

    SQL can only see its own drives, so you will need to copy the files over, or backup and restore over a UNC path providing the SQL server has access to the share.

  • February 12, 2013 at 7:07 am

    #1586996

    i believe that unless you have started your instance with trace flag 1807, the server can only attach databases that exist on local, and not network storage.

    the trace flag is here:

    http://social.technet.microsoft.com/wiki/contents/articles/13105.trace-flags-in-sql-server.aspx

    and heres the first google link i found describing the flag a little bit:

    http://www.midnightdba.com/DBARant/?p=464

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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