Cannot Open the Database

• Nuts

  SSCrazy

  Points: 2547

  More actions

  November 5, 2006 at 12:42 pm

  #114942

  Hi guys

  I am trying to open a database which is on a shared drive. The database is stored in the 'my network places'. Now when I try to copy  the database into my hard disk, it says "sharing violation, file in use' whereas nobody else is using it except me.

  SQL does not recognise the shared path as it is installed locally on my hard disk.

  Im using sql server 2005

  PLease help guys

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  November 5, 2006 at 3:20 pm

  #669980

  One,

  no other service/person can be accessing the files at all.

  if you want to use the share you will have to enable the correct trace flag so sql server will mount the databaase files.

  http://support.microsoft.com/kb/304261

  You can't copy or modify the files if they are in use by sql server.

  Wes