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 |
|
svijay
Starting Member
2 Posts |
 Posted - 2005-08-09 : 15:30:18
|
| hi all, I have got some problem while taking back up of sql server transaction log file. Now its size is nearly 60 GB. And we have got less space in the server. so my idea is I need to take back up of this transaction log file at the same to wann reduce the size of transaction log file. But Im not sure how could I do this. Is there any experts help me out from this problem. I appreciate yours vauable suggestions. Regards Vijay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-09 : 15:32:47
|
| You first need to truncate it since you are out of disk space.BACKUP LOG DBNameGoesHere WITH NO_LOGThen you'll need to shrink it down to a reasonable size.Then you need to decide whether you want point in time recovery. If you do, then you need to start backing up your transaction log more frequently. If you don't, then change your recovery model to SIMPLE so that you don't run into this problem again.Tara |
 |
|
|
svijay
Starting Member
2 Posts |
Posted - 2005-08-09 : 15:57:46
|
thx tara let me try to do the way u said and will get back to u quote:
Originally posted by tduggan
You first need to truncate it since you are out of disk space.BACKUP LOG DBNameGoesHere WITH NO_LOGThen you'll need to shrink it down to a reasonable size.Then you need to decide whether you want point in time recovery. If you do, then you need to start backing up your transaction log more frequently. If you don't, then change your recovery model to SIMPLE so that you don't run into this problem again.Tara
|
|
|
|
|
|
|
Urgent help regd reducing the size and backing up