Deleting The Transaction Log With No Data Loss (Movie)

[RifleMorre]

Download Url: http://vd0team.com/Guides/[Guide]%20...saction%20Log/
Guide Taken From: http://forum.ragezone.com/showthread.php?t=24131
Scripts Used In The Movie:

USE master
go
sp_configure 'allow updates',1
go
reconfigure with override
go
update sysdatabases set
status=-32768 where dbid=DB_ID('MuOnline')
go
sp_configure 'allow updates',0
go
reconfigure with override
go

USE master
go
dbcc rebuild_log('MuOnline','D:\muserver\db\MuOnline_log.ldf')
go
dbcc checkdb('MuOnline')

alter database MuOnline
set multi_user

If you like it give me some reputation :P

[MentaL]

[PimpnMu]

filefront link doesnt work :(

[RifleMorre]

Guide Updated NEw Link 100% Faster

[DhoTjai]

You could also change recovery from Full to Simple. Then use database shrink and it will shrink the log.

[RifleMorre]

Either way work it depends on how you look at it :P this deletes the transaction log and starts it from scract at 512kb's :P while your method only shrinks it :P

[themad]

 USE master 
GO 
backup log [muonline] with truncate_only 
GO 
dbcc shrinkdatabase([muonline],0) 
GO

This is Much Much Better

- Clears the log completely (Not instantly)
- Does not need shutdown or deleting anything.

[dforthster]

Why the video wont work for my mssql =(... pls help. I repeat the guides several time but it wont work.. hhhhhhhhhmmmm I am to late enough to ask about this one, well im new in making private MU server eventhough mine works fine but still wanna delete some logs files without lossing any data. hhhhhhmmm what about shrinking databases, can someone pass me a link bout the guides of shrinking MU online database???? i'd try it but still the log files size same with the original, wont even loss any bytes... =( hhhhhhhhhmmmm should I stop mu server first??? before shrinking databases??? hhmmm give me and idea pls. here my MSN lacida@gmail.com, hope can send me the guide link... TY in advance =D:geek:

[nand0stylusmu]

This Link Dont Work

[GrandBear]

the download link doesn't work =(

can u repair plz?


:D