Move TempDB Database off of the SAN

Douglara

I have a system configured with Windows 2000 and SQL Server 2000
Clustering (active/passive). Both SQL Servers have a local E:\ drive
with the same directory structure. I would like to move the tempdb
off of the shared SAN and on to the E:\ drive. I don't foresee any
issues with this but wanted to know if anyone else has encountered
problems with this.

Jul 20 '05 #1

Subscribe Post Reply

3289

Greg D. Moore $Strider$

"Douglara" <re***********@ps.net> wrote in message
news:af**************************@posting.google.c om...

I have a system configured with Windows 2000 and SQL Server 2000
Clustering (active/passive). Both SQL Servers have a local E:\ drive
with the same directory structure. I would like to move the tempdb
off of the shared SAN and on to the E:\ drive. I don't foresee any
issues with this but wanted to know if anyone else has encountered
problems with this.

In theory it should work since the tempdb is recreated at startup.

But I'd ask why? I'm assuming you're looking for a performance improvement?

And suggest asking over in the microsoft.public.sqlserver.clustering group
to be sure.

Jul 20 '05 #2

Similar topics

tempdb in RAM?

by: New DB Admin | last post by:

Is it a good thing to do? what are the cons? Are there any risks? (this is an ISP database running 24 hrs) I have sql 6.5 on Win NT with 256 MB Ram (64 MB reserved for SQL Server). tempdb size is...

Microsoft SQL Server

One Command Keeps Causing "'tempdb' is full" Error

by: Jay Chan | last post by:

I keep getting the following error message when I run a serie of SQL commands: Server: Msg 9002, Level 17, State 6, Line 15 The log file for database 'tempdb' is full. Back up the transaction...

Microsoft SQL Server

TEMPDB now at 4 GB

by: Deaconess | last post by:

I have shut down the SQL agent, rebooted the box and still my TEMPDB is at 4 GB plus. Is there any way to shrink it another way?

Microsoft SQL Server

Locking on Tempdb...

by: arijitchatterjee123 | last post by:

Hi Group, I am facing a problem regarding locking. I have created a Stored Procedure in my Database. In this Stored Procedure Temprary Tables get created and after that values are inserted in...

Microsoft SQL Server

tempdb log full error with plenty of disk space available

by: New MSSQL DBA | last post by:

has anyone met with this before? the setting is SQL2K with SP3 on a 2 node active-active W2K3 cluster. on one of the machine, it occasionally prompts for the following error: "The log file for...

Microsoft SQL Server

Tempdb grows rapidly and fills up disk space

by: SQL Server | last post by:

Hi, The tempdb file on one of our servers grew very large and used all available disk space. This is SQL Server 2000 SP4. I have installed hotfix version 8.00.2187. I opened a profiler trace but...

Microsoft SQL Server

Trigger on a table in TempDB

by: Karthik | last post by:

I have an application that creates and makes use of a table in tempdb. My problem is that I have a couple of triggers on this table that get dropped everytime SQL Server restarts (due to the fact...

Microsoft SQL Server

Transaction log and tempdb

by: Kurt | last post by:

Hello I have questions about how works transaction log et the database tempdb in SQL Server and I hop you could help me - Is it possible to reduce the size of the transaction log fil during an...

Microsoft SQL Server

TempDB won't shrink

by: Thomas R. Hummel | last post by:

I was able to find a few posts on this topic, but none of them quite seemed to fit the situation, so I'm hoping that someone else might be able to help me here. I have a client who is using SQL...

Microsoft SQL Server

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing