General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
>I have an MSDE database being used by an application, but the tempdb log file keeps getting too large. How can I connect to this to set it to simple logging? The server space is very limited and specific to this application. There is not room to install SQL Server Enterprise.
>
>Your help is greatly appreciated.
Rollin,
Restarting MSDE SQL Server service should resize the transaction log of the tempdb database to its original size.
Cheers,
Zoran
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only