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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2012-02-01 : 06:34:56
|
| Hi,My database log file size is very large. i run following script to get file size.SELECT DB_NAME(database_id) AS DatabaseName,Name AS Logical_Name,Physical_Name, (size*8)/1024 SizeMB, ( (size*8)/1024 ) / 1024 SizeGBFROM sys.master_filesFile size : 1034971 MB and 1010 GB problem is that i do not have space available of 1010 GB to take backup. is there any way to set translog backup back with less size or with zero size.after taking backup i have to shrink log file. so pls guide me |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-01 : 08:07:46
|
| If you're on Enterprise edition you could take the backup with compression.Otherwise, switch to simple recovery, get the log back to a reasonable size, switch back to full recovery, take a full backup and schedule regular log backups.Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Database log backup of large file