-
Tempdb expand
Hello:
I'm using SQLServer 6.5 sp3. Right now I need to increase the size of tempdb but I dont know
how.
By default this db is localized in the master db with 2Mb, but I want to resize the tempdb with
300Mb of data and 200Mb of log, this 'cause somebody says that his application needs that
size in tempdb.
How can I expand my tempdb without all the expansion goes to the logs, I mention this 'cause
each time I expand tempdb all the increase goes to log part and the data remains with 2Mb.
Is correct to have this sizes(300Mb data- 200Mb log) ?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|