开发者

How to incease transaction log manually in sql server 2005?

开发者 https://www.devze.com 2022-12-12 08:19 出处:网络
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?

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)
0

精彩评论

暂无评论...
验证码 换一张
取 消