October 9, 2008 at 10:33 am
You could get a bit of space back by doing a backup of 2 then - as you're in simple mode do a log backup with truncate only. This will give you back quite a bit of space.
But, as a side issue - are you absolutely, positively, 100%, utterly and compeltely dead certain you want these 24/7 databases in *simple* recovery mode? Sounds like a bad idea to me, if you don't mind me saying
October 9, 2008 at 10:52 am
it dosent seems to be large databases, i would shrink log files and save space, take a backup and then restore it to the place where you need them. its not going to take long 🙂
October 9, 2008 at 12:45 pm
I am sorry,only gave examples,because I couldn't understand how you can shrink files and when I need to do it. All of my databases will be change from simple to full, but not temp.Should I keep any other system db as simple? I am new and finding bugs everyday. This is server is located in other state and I need to move it to another state. Here is my data just for one server.Thank you for your help.
Data Logs
masterSIMPLE 512 64
tempdbSIMPLE 2680 2768
modelFULL 152 3048
msdbSIMPLE 90864 864
Database1 FULL 3840 1920
Database2 FULL 45696 1280
Database 3 FULL 23680 384
Database 4FULL 6400 3200
Database 5BULK_LOGGED 7552 27756
Database 6FULL 1920 640
Database 7FULL 790400 36328
Database 8SIMPLE 9600 4048
Database 9FULL 64000 32128
Database 10SIMPLE 2328 160
Database 11FULL 256 3072
October 10, 2008 at 7:26 am
Can some one please help me to do shrink files. Thank you so much
October 10, 2008 at 7:54 am
Hi,
As mentioned in the previous comments you can use DBCC SHRINKFILE to shrink the files.
http://msdn.microsoft.com/en-us/library/ms189493.aspx
Also as mentioned this may effect performance whilst running.
Hope this helps,
Jackal
October 10, 2008 at 8:05 am
yulichka (10/10/2008)
Can some one please help me to do shrink files. Thank you so much
For any of your simple recovery databases, you can do so by backing up then doing a backup log with truncate only. Given that some of your transaction logs are very large this should save you a lot of space.
Personally, I'd try this before shrinkfile as with this you may well find that for files linked to active databases they just grow again because they need more space
October 10, 2008 at 8:21 am
Sorry to ask a stupid question, If I back up logs with truncate only, do I need to restore my logs after that? When I select shrink file in SQL Server after click finish, what do I need to do? I tried to shrink files on my testing server and nothing happend.Thank you
October 10, 2008 at 12:07 pm
If you do backup logs with truncate only, there is nothing to restore. Because you don't actually backup.
But let me ask you another question: Is this production or development system ?
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply