Sql Db Size ?

[littlemoon]

sql DB nunchi data delete chesthe a database size decrease avadha ? almost 50GB delete chesanu aina no effect

shrinkfile option use cheyamantaunaru google chesthe..idhi use chesthe em avthundi performance issues untaya??

and data delete chesina space antha etttu velthunatu ??

[Vaampire]

[font=arial, sans-serif][size=3]SELECT name ,size*8/1024 SIZE_MB , (size*8/1024)/1024 SIZE_GB FROM [master].[sys].[master_files] [/size][/font]
[font=arial, sans-serif][size=3]motham anni databases and logs size isthundi[/size][/font]


[font=arial, sans-serif][size=3]run this query[/size][/font]
[font=arial, sans-serif][size=3]some times, database size kantey database log file size chaala ekkuva vuntadi.[/size][/font]
[font=arial, sans-serif][size=3]data delete chesina size thaggaledhu antey, log files size ekkuva vunnatu[/size][/font]
try [font=arial, sans-serif][size=3]shrinking the log files[/size][/font]

[Vaampire]

shrink chesthey performance increase avuthundi. decrease kaadu.
but it is adviced to shrink the database after taking a backup/

[ChampakDas]

it will increase the performance
[quote name='littlemoon' timestamp='1347568365' post='1302471824']
sql DB nunchi data delete chesthe a database size decrease avadha ? almost 50GB delete chesanu aina no effect

shrinkfile option use cheyamantaunaru google chesthe..i[b]dhi use chesthe em avthundi performance issues untaya?[/b]?

and data delete chesina space antha etttu velthunatu ??


[/quote]

[ChampakDas]

GP
[quote name='Vaampire' timestamp='1347568590' post='1302471865']
[font=arial, sans-serif][size=3]SELECT name ,size*8/1024 SIZE_MB , (size*8/1024)/1024 SIZE_GB FROM [master].[sys].[master_files] [/size][/font]
[font=arial, sans-serif][size=3]motham anni databases and logs size isthundi[/size][/font]


[font=arial, sans-serif][size=3]run this query[/size][/font]
[font=arial, sans-serif][size=3]some times, database size kantey database log file size chaala ekkuva vuntadi.[/size][/font]
[font=arial, sans-serif][size=3]data delete chesina size thaggaledhu antey, log files size ekkuva vunnatu[/size][/font]
try [font=arial, sans-serif][size=3]shrinking the log files[/size][/font]
[/quote]
[quote name='Vaampire' timestamp='1347568635' post='1302471872']
shrink chesthey performance increase avuthundi. decrease kaadu.
but it is adviced to shrink the database after taking a backup/
[/quote]

[mustang302]

[quote name='ChampakDas' timestamp='1347568705' post='1302471888']
it will increase the performance
[/quote]

[littlemoon]

thansk query run chesanuu ..
data file size e ekuva undhii still logfile only 15GB

and data file size ila chusthe correct size chupishtundi delete tarvtha chupivalsindi but normal ga DB properties nunchi old size e chupishtundi any clue y?

[Vaampire]

[quote name='littlemoon' timestamp='1347568823' post='1302471917']
thansk query run chesanuu ..
data file size e ekuva undhii still logfile only 15GB

and data file size ila chusthe correct size chupishtundi delete tarvtha chupivalsindi but normal ga DB properties nunchi old size e chupishtundi any clue y?
[/quote]
log file 15gb antey ekkuva. shrink ela chesthunav????
query tho shrink chesthunava lekha wizard thona???

[littlemoon]

[quote name='Vaampire' timestamp='1347568944' post='1302471946']
log file 15gb antey ekkuva. shrink ela chesthunav????
query tho shrink chesthunava lekha wizard thona???
[/quote]

shrink cheyaledhu ipati daka..

adhe searching ela cheyali ani...

15gb ekuva ante motham delete chesthe this is just a testing server...

[mtkr]

[url="http://dba.stackexchange.com/questions/10245/shrink-database-after-drop-table"]http://dba.stackexchange.com/questions/10245/shrink-database-after-drop-table[/url]


[url="http://dba.stackexchange.com/questions/11316/shrink-a-database-below-its-initial-size"]http://dba.stackexchange.com/questions/11316/shrink-a-database-below-its-initial-size[/url]


[url="http://www.sqlservercentral.com/Forums/Topic1047792-146-1.aspx"]http://www.sqlservercentral.com/Forums/Topic1047792-146-1.aspx[/url]

[horizontallycut]

[img]http://www.andhrafriends.com/uploads/gallery/album_13/gallery_24383_13_3172.gif[/img]

[Vaampire]

USE XYZ
GO
exec sp_helpfile
go
BACKUP LOG XYZ WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE ('XYZ_log', 1)
GO
DBCC SHRINKFILE ('XYZ', 1)
GO
exec sp_helpfile
go





xyz is name of database

[ChampakDas]

15gb aa kada..why do you want to shrink the db?
[quote name='littlemoon' timestamp='1347569168' post='1302471978']

shrink cheyaledhu ipati daka..

adhe searching ela cheyali ani...

15gb ekuva ante motham delete chesthe this is just a testing server...
[/quote]

[littlemoon]

[quote name='Vaampire' timestamp='1347569563' post='1302472061']
USE XYZ
GO
exec sp_helpfile
go
BACKUP LOG XYZ WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE ('XYZ_log', 1)
GO
DBCC SHRINKFILE ('XYZ', 1)
GO
exec sp_helpfile
go





xyz is name of database
[/quote]
thankuuuuuuu.... indaka chesthe kaledhu my query was wrong...

so idhi just shrink cheshtundi file nothing more kadha???

he truncate only ante does it delete even log file ??

[Vaampire]

[quote name='littlemoon' timestamp='1347569678' post='1302472076']
thankuuuuuuu.... indaka chesthe kaledhu my query was wrong...

so idhi just shrink cheshtundi file nothing more kadha???
[/quote]
yupe. nenu chaala sarlu use chesa. no issues till now.