Re: Splitting Data and Logs

Tech-Archive recommends: Speed Up your PC by fixing your registry

Neil,

ok I think you did that wrong, add the disks that are not showing up as dedencies to the SQL server resource, you will need to stop the SQL service first then go to properties of the SQL Server service and modify the dependencies tab so that each of the missing drives shows up under Resource Dependencies for the SQL Server Properties.

That should do the trick.

Use the following to see if SQL instance is actually seeing the drives.

select * from ::fn_servershareddrives()


John Vandervliet..



Open the cluster admin tool
"Neil Paddock" <NeilPaddock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:378CC919-885B-4C52-9167-6624799A23DE@xxxxxxxxxxxxxxxx
I have set the dependencies on the logs disk resource but still can't see it
under the database properties in SSMS?

I have restarted cluster services on both nodes - is there anything else I
have missed?

Thanks,
Neil Paddock.

"Geoff N. Hiten" wrote:

You must add the disks to the resource group for your SQL Server AND make
the SQL service dependant on them.

Once you have this configured, SQL will display and allow these disk devices
to be used for database file storage.

You can use SSMS to change the default location once the dependencies are
set correctly.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"Neil Paddock" <NeilPaddock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E96CD8BB-AA4E-49EE-B454-14BFA1316805@xxxxxxxxxxxxxxxx
>I am having difficulty setting up my disks on my SQL 2005 cluster. I >have
>a
> data disk and log disk for each instance (3) but when trying to setup a
> new
> DB, when I try to choose the log drive it does not appear.
>
> I remember choosing a location during setup for data files and this is
> what
> is displayed.
>
> How do I go about splitting my data and log files for each database
> instance?
>
> Thanks,
> Neil Paddock.



.

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)