Re: Access Denied Error when attaching a Database file

From: Keith Wilson [MSFT] (Keith.Wilson_at_online.microsoft.com)
Date: 10/06/05


Date: Wed, 5 Oct 2005 15:36:24 -0700

Is there a backup of these database(s), and is the backup file on a
different hard drive or server?

Regards,
                        Keith

This posting is provided "as is" without inferring rights or warranties.

"WayneM" <WayneM@discussions.microsoft.com> wrote in message
news:360AE82B-6E0D-4B75-847C-9C79247CDCFD@microsoft.com...
> Is it possible that the database file is corrupted? I am able to copy the
> Master database file, but not my application database. Is there a simple
> way
> to determine if the file is or is not corrupted?
>
> Thanks,
>
> WayneM
>
> "Hari Prasad" wrote:
>
>> Hi,
>>
>> See if the SQL Server service starup accoung have read/write access to
>> the
>> folder.
>>
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "WayneM" <WayneM@discussions.microsoft.com> wrote in message
>> news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@microsoft.com...
>> >I have a server that crashed, so a new OS was installed. I now have
>> >access
>> > to the drive where the database file exists. I am now trying to either
>> > copy
>> > that file onto a new server or reattach it to a new insance of SQL
>> > Server.
>> > In both cases I get a Access denied error.
>> >
>> > Any suggestions on how to get around this ?
>> >
>> > Thanks in advance,
>> >
>> > WayneM
>>
>>
>>



Relevant Pages

  • RE: Re-occuring error message SceClient 1202 Application Log error
    ... this message may occur if Group Policy ... database file is corrupt. ... This posting is provided "AS IS" with no warranties, ... Migrating to a new 2003 server in a single server enviornment ...
    (microsoft.public.windows.server.migration)
  • Multiple SharePoint Database files
    ... Not sure if I am posting in the right group with this question.... ... We have a SharePoint Portal 2003 server that has a single 150 GB content database file and we would like to limit the size of this file and force SharePoint to start using a newly created database file, ... John ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Hardware upgrade
    ... exclude the previous backup file so it was a large backup file!) ... Copied the backup files to the RAID array - these were the only ... problem by temporarily using the network card from the old server!) ...
    (microsoft.public.win2000.setup_upgrade)
  • Re: Help with Server recover
    ... A VHD file is a Virtual Hard Disk. ... Server 2008 most likely includes some tools to mount them locally, or perhaps the backup program can restore from them. ... not allow me to use the USB drive so I transferred the backup file to the ...
    (microsoft.public.windows.server.general)
  • Need WAN/Branch OfficeSolution
    ... We are looking for the best recommendation for the following situation ... our server is Windows 2003 Standard Edition and it has network ... We have text documents & a database file for a program we ... currently sharing a cable Internet connection The workstations in BB ...
    (microsoft.public.windows.server.sbs)