Friday, February 24, 2012

Database recovery issue

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
I'm not clear on what you mean by the last part of "SQL does
not recognise the shared path as it is installed locally on
my hard disk". You don't want to use network shares for SQL
Server data, log files.
In terms of not being able to access the files to copy to
your hard drive, you can use FileMon from sysinternals to
see what process or what user has the files in use:
http://www.sysinternals.com/Utilities/Filemon.html
-Sue
On Sun, 5 Nov 2006 11:39:02 -0800, mita
<mita@.discussions.microsoft.com> wrote:

>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

No comments:

Post a Comment