August 13, 2014 at 3:52 am
we have 10 DBs on the instance and all rests on the same drive...
they are all of 80 MB of sizes..
All the DBs are in SIMPLE recovery mode.
Cheers,
- Win
"Dont Judge a Book by its Cover"
August 13, 2014 at 4:03 am
Can you temporarily move one of those other databases somewhere else?
Their recovery model is irrelevant, I just want to know if you can make some space on the drive.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2014 at 4:32 am
Yeah, I know their recovery models are irrelevant to mention here.
I cannot move files right now, I need authorization again for this.
Why am I not able to backup still, what would be this bitmap errors, I am stuck with this.
I would like to get it fixed anyways now, to get the processes running.
Cheers,
- Win
"Dont Judge a Book by its Cover"
August 15, 2014 at 9:49 pm
can anyone help, what if the DB is switched from FULL to SIMPLE and SIMPLE to FULL. what happens in back end ?
How this bitmap fixes and how it got cleared all the errors ?
I found an article regarding this issue, the change of recovery model from simple > full and backup fixes the bitmap issue.
I switched to full from simple and performed full backup, log backup, shrinked log file to min extent.
now the 58 GB size got decreased.
Again I switched back to simple recovery mode and performed full and differential backups.
this cleared the issue and now the backup cycle runs fine.
Cheers,
- Win
"Dont Judge a Book by its Cover"
August 18, 2014 at 6:15 am
That's why I suggested taking another backup in the first place. Glad it's working again.
http://technet.microsoft.com/en-us/library/ms345448%28v=sql.105%29.aspx
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply