How to add files to Tempdb using Enterprise Manager?

This may seem easy but better to ask than mess up. Of course have now
seen the articles about adding files to the tempdb but none really indicate
the proper method for doing this they just say do it. Do I just right click
on Tempdb, properties, select data files and then just add the files and make
sure they are all the same size? I do not need to add more Log files just
the data files, correct? Once this is done does it require a restart of SQL?
This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
a TON of activity on it.
Thank you!Inline.
"Transam388" wrote:
> This may seem easy but better to ask than mess up. Of course have now
> seen the articles about adding files to the tempdb but none really indicate
> the proper method for doing this they just say do it. Do I just right click
> on Tempdb, properties, select data files and then just add the files and make
> sure they are all the same size?
You can do this. I'd prefer to just run a series of T-SQL statements:
ALTER DATABASE tempdb ADD FILE (...)
> I do not need to add more Log files just the data files, correct?
Correct (unless you need more tempdb log space and the current log file
can't be grow any larger).
> Once this is done does it require a restart of SQL?
No.
> This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
> a TON of activity on it.
> Thank you!

How to add files to Tempdb using Enterprise Manager?

This may seem easy but better to ask than mess up. Of course have now
seen the articles about adding files to the tempdb but none really indicate
the proper method for doing this they just say do it. Do I just right click
on Tempdb, properties, select data files and then just add the files and make
sure they are all the same size? I do not need to add more Log files just
the data files, correct? Once this is done does it require a restart of SQL?
This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
a TON of activity on it.
Thank you!
Inline.
"Transam388" wrote:

> This may seem easy but better to ask than mess up. Of course have now
> seen the articles about adding files to the tempdb but none really indicate
> the proper method for doing this they just say do it. Do I just right click
> on Tempdb, properties, select data files and then just add the files and make
> sure they are all the same size?
You can do this. I'd prefer to just run a series of T-SQL statements:
ALTER DATABASE tempdb ADD FILE (...)

> I do not need to add more Log files just the data files, correct?
Correct (unless you need more tempdb log space and the current log file
can't be grow any larger).

> Once this is done does it require a restart of SQL?
No.

> This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
> a TON of activity on it.
> Thank you!

How to activate the MSDTC service?

Hello,

As newbie in server country I try a course example to test a distributed transaction accessing both SQL Server 2005 and Sql Server 2005 Express.

But I get an error message saying:
>MSDTC on server is not available

I Internetted somewhere that MSDTC stands for TransactionManager service.
If I look in the 'Services' list I do not see something like MSDTC, so I think it is not installed or started.

How do I install or activate the MSDTC service?

Thanks in advange,
Henk

Hi,

What OS are you using? I have Win2K3 and I do see "Distributed Transaction Coordinator" as a service.

Thanks

Waseem

|||

In the services list it should be named "Distributed Transaction Coordinator".

You should check ControlPanel->AdministrativeTools->Component Services->Computers->My Computer->Properties.

Have a look at http://msdn2.microsoft.com/en-us/library/ms684146.aspx for a general documentation.

|||

Thanks both of you!

I'm using WinXP Prof and I see a 'Distributed Transaction Coordinator' service thats waiting to be started....
After starting it, my program runs fine!

regards,

Henk