Re: Splitting Data and Logs

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

  • Re: % Disk Time
    ... Avg and current Disk queues instead. ... > I have separate drives each SQL Server database: ... > then your SQL Server ... >> Is not a very reliable indicator of an IO bottleneck. ...
    (microsoft.public.sqlserver.server)
  • Re: Server stops responding
    ... you may want to track your database with SQL Server Profiler to see if some processes takes longer then they should take. ... Physical Disk: % Disk Time (seperately for your OS and database disks, ...
    (microsoft.public.sqlserver.clients)
  • Re: 2 million records
    ... first point, its not a datawarehousing question, but a general SQL Server ... question & Web Developper question. ... second is not relevant to fine tune your database. ... Look at the avg disk queue length perf counter, ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: SQL Server Issues ::: ( how to avoid this issues )
    ... The file sizehave all the info you need for DISK REINIT. ... Log pages where SQL Server expects data pages is automatically handled over time. ... Or just transfer the stuff into a new database. ... >>> You guys are thinking just in the higher level of IT security policies... ...
    (microsoft.public.sqlserver.server)
  • Re: Create database fails because of lack of disk space...
    ... I've never seen things like that so just shooting in the ... Is it possible that SQL server gets really funky and doesn't read OS ... causing SQL server to still think the disk drive is full? ... > CREATE DATABASE fails ("CREATE DATABASE failed. ...
    (microsoft.public.sqlserver.server)