Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-11-13 : 08:10:19
|
| Hi,Version: SQL2000One of my database is created with Simple Recovery Mode and my existing procedure has the backup log syntax to truncate the log as below.backup log test with no_logcheckpointdbcc shrinkfile ('test_Log', 4500, TRUNCATEONLY)I know that it obviously fail, as you cannot backup the log when its in SIMPLE recovery mode but when I check the database properties, the log file exists with size 2017 MB, unrestricted growth 128MB.Ques 1: Is there a way that we can truncate the log though it has SIMPLE mode recovery. I can comment those lines if the backup log is not possible. Pls. advise.Ques 2: On looking at the db properties -> General page, the Space available is 0.00 MB. We noticed that the .mdf, .ldf and .ndf mapped to the disk has appropriate space in the server. Can you advise what this space available indicates and how to recover the space?Thanks in advance. |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-11-13 : 08:34:40
|
| In simple recovery mode, the log gets truncated automatically whenever there is a checkpoint or backup of data. So i can very comment those lines.I need the answer for quest no. 2 |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-13 : 08:38:14
|
| data files set to unrestricted growth? |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-11-15 : 21:57:33
|
| Out of 3 data files, two is set to unrestricted growth and the other one set to restricted to 200256 mb with the intial size 200255? Is it the issue with the intial size and its restricted growth? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-15 : 22:12:52
|
| yes |
|
|
|
|
|
|
Backup Log error