CODEWITHSUNDEEP
sql-server
Alex
Alex

Reputation: 1963

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 incease this 10MB to more ... Where is the option for increase this size manually in sql 2005?

hoping ur response,

Upvotes: 0

Views: 178

Answers (1)

kevchadders
kevchadders

Reputation: 8335

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)

Upvotes: 1

Related Questions