Posted by Greg D. Moore \(Strider\) on 04/18/07 14:15

<war_wheelan@yahoo.com> wrote in message
news:1176903880.900635.102490@y80g2000hsf.googlegroups.com...
> On Apr 1, 10:01 am, "Greg D. Moore \(Strider\)"
> <mooregr_deletet...@greenms.com> wrote:
>> <war_whee...@yahoo.com> wrote in message
>>
>> news:1175350571.321521.171840@b75g2000hsg.googlegroups.com...
>>
>> > I've figure out how to reboot the server and make the networked
>> > database accessible again. After the reboot, I need to manually
>> > restart the SQL Server service.
>>
>> > Does anyone have an idea why I need to restart the service when I is
>> > configured to start automatically? Also is there a way to have this
>> > happen automatically via a script of something?
>>
>> Yes, my guess is that SQL Server is starting BEFORE the workstation
>> service
>> (I believe that's the one required) so that UNC shares are not available
>> until AFTER SQL Server starts.
>>
>> Restarting SQL Server works because the drives are available at that
>> point.
>>
>> You can go into the properties of the SQL Server service and play around
>> with dependencies and that should allow you to fix it.
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com
>> http://www.greenms.com/sqlserver.html
>
>
> I tried setting the database to auto_close and also tried read_only
> which didn't correct the problem.

Ok, not really sure why you took this approach. Did you try my advice?



> What I mean is I still had to
> restart the service when the database was set to read_only, but I was
> able to access it. I also found that accessing the tables from the
> read_only database was quicker. On the other hand, when I set the
> database to auto_close I couldn't access it after a reboot even when
> restarting the service. The only was that I was able to access the
> database was to remove the auto_close options.
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

• Next in forum: Re: DB Replication or Table Replication via triggers?
• Prev in forum: Re: DB Replication or Table Replication via triggers?
• Thread view: Re: I have a database on a network drive that I use for archiving purposes, but when the server is rebooted the database becomes suspect.

[Reply to this message]