How to recreate tempdb in SQL 2000

JOSHUABT used Ask the Experts™

During the process of VMWare virtualization of SQL2000 (SP4) server, tempdb was lost.
Tempdb resides on SAN drive of physical server but only local drive ( C ) was virtualized
and it's missing in virtual server now.

Of course, SQL server service won't start due to missing tempdb.
Is there anyway that I can recreate tempdb?

Thank you for your help.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Paul SolovyovskySenior IT Advisor
Top Expert 2008
For SQL, Exchange, Database servers in general it is normally best to do a cold migration to vmware. You can also use Acronis or Symantec Backup Exec System Recovery to image the server and convert the image to a virtual machine.  

Did you disable SQL services before you converted?
If you still had access to the location of the tempdb, restarting the service should have recreated it.

If that fails, take a look here.  The suggestion is to start SQL minimally (-f parameter) and then applying the supplied script ..


Top Rung,
The discussion forum in your link suggested to temporarily create a drive in the virtual machine  and assign the same drive letter as the physical machine so that SQL can automatically create tempdb.
It solved my problem.

Thank you for your help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial