hi friends,
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,
+1
A:
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)
kevchadders
2009-11-26 08:43:58
That table is blank,i use add button to add datafile, but the problem is file type is "Data" only , there is no Log File
Alex
2009-11-26 09:04:16
When you add a new file, you should be able to change the 'File Type' to Log, as well as changing the logical name, filegroup and Initial Size. If you still having problems make sure you have the correct SQL Permissions to do this. eg. being part of the db_owner role
kevchadders
2009-11-26 09:50:55