The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Monday, April 22, 2019

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

TJs 1st School Day

  bob Links
index
It puts eloquence in an orator, it will make the philosopher talk profoundly…it is a great friend to the trught…it will put courage in a coward…it is the seal to a bargain…it is the nourisher of mankind. - John Taylor
Wider View Insert

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
          Compressed Backups
          Moving the master an...
          Start SQL Server and...
          SQLAgent Job Waiting...
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
Windows OS

Insert Category

Will be added as a sub-category of, Backup
Start SQL Server and move / create new TempDB

The following steps explain how you can create a new tempdb database. With this workaround, you are able to successfully start the SQL Server service.

 1. If they exist, rename the current Tempdb.mdf and Templog.ldf files.

If the files do not exist, that is one possible reason for the suspect status, the files are missing.

2. Start SQL Server from a command prompt by using the following command:

sqlservr -c -f -T3608 -T4022

For SQL Server 2000 named instances you have to add the additional -s parameter.