Changing the db and log file location on SQL 2000 Cluster

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Changing the db and log file location on SQL 2000 Cluster

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Server Products] >> SQL Server >> Changing the db and log file location on SQL 2000 Cluster

Page: [1]

Message

<< Older Topic Newer Topic >>

Changing the db and log file location on SQL 2000 Cluster - 8/6/2008 5:09:03 PM

ddoyley

Posts: 77
Score: 0
Joined: 11/14/2002
Status: offline

Is this possible or will it cause problems. The DB is installed where I want it but the tempdb and logfiles are also in the same location. I would like to separate these.

_____________________________

SMS 2003
Advanced Security
Schema is extended

Post #: 1

RE: Changing the db and log file location on SQL 2000 C... - 8/6/2008 8:14:10 PM

jsandys

Posts: 530
Score: 17
Joined: 3/24/2005
From: San Antonio, TX
Status: offline

Not a problem at all. SMS doesn't know anything about these, it's essentially a black box to SMS/ConfigMgr or any other DB application for that matter. There are lots of articles on the web describing how to mve the tempdb, just do a search. The log files for db are pretty easy to move also, you will have to stop the db though so a small amount of downtime is needed. Here's a link to a decent post: http://blog.stevienova.com/2007/12/11/sql-moving-log-files-for-an-existing-database-to-another-drive/. You can also take the route of detaching the database completing and then reattaching; in this process you will be able to specify the new locations.

_____________________________

Jason
________________________________________
http://myitforum.com/cs2/blogs/jsandys/default.aspx

(in reply to ddoyley)