How to incease transaction log manually in sql server 2005?
in my sql 2005 , 10 MB of disk space will be allocated for transaction logs.
I wand to i开发者_JAVA技巧ncease this 10MB to more ... Where is the option for increase this size manually in sql 2005?
hoping ur response,
In SQL Server Management Studio
- Right click on your Database and select Properties
- Select the Files page
- You should now be presented with a table view showing your Data File and Log File
- Click on the Log File in the list (normally second in list)
- You should be able to change the Initial Size (MB) to an additional 10MB
- Clicking OK at the bottom should save your changes (you can check this by repeating the first few steps)
精彩评论