[dba-SQLServer] SQL Server "locks up"

Also,  You can change the existing default paths for all future databases
you create by right clicking on your server name in Management Studio and
selecting the database properties.  This will change the behavior of where
you want your log files in the future, but not move any existing log files,
to do that you must EITHER backup the database and restore it (choosing the
locations of the files explicitly) OR detach and re-attach the database
files with the explicit location of the log files... I think you already
have the syntax for that so I won't repost...
-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Wed, Jun 10, 2009 at 1:18 PM, Francisco Tapia <fhtapia at gmail.com> wrote:

> When you are doing the install you can specify the default location of
>> these files (i'll google for how to change this), also for existing
>> databases just detach and re-attach with the log file on it's specific
>> location, for new databases you can specify the new location for log files,
>> none of the existing databases will automatically move the log files to a
>> new location, this must be done manually.
>>
>>
>> -Francisco
>> http://sqlthis.blogspot.com | Tsql and More...
>>
>>
>> On Wed, Jun 10, 2009 at 8:54 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:
>>
>>> Is there a generic setting to tell SQL Server to place log files on a
>>> specific drive?  Is it by the
>>> database?  How is this done?  I am going to set up a RAID 1 pair of 512
>>> gig drives just to put the
>>> log files on, but I do not know how to specify that logs should go there.
>>>
>>> My business has me setting up a new database for each order.  In fact
>>> what I actually do is copy an
>>> existing "template" database, renaming it to the order name.  The log
>>> files can get pretty large
>>> (tens of gigs) depending on the order and processing involved.  it would
>>> be nice not to have to
>>> remember to tell SQL Server to place the logs in a specific place each
>>> time I create a database.
>>>
>>> John W. Colby
>>> www.ColbyConsulting.com
>>>
>>> <snip>