Database log full

What to do when the database log file is full?
TIRislaabackup transaction log
see: "Transaction Log Backups" in BOL
"Tor Inge Rislaa" wrote:

> What to do when the database log file is full?
> TIRislaa
>
>|||Hi
BACKUP/ and DBCC SHRINKFILE if you want to reduce a physical size of the
file
"Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
news:uYMARE5XFHA.3096@.TK2MSFTNGP15.phx.gbl...
> What to do when the database log file is full?
> TIRislaa
>|||I am a bit new to administrating an sql server. How to backup the
transaction log trough the Enterprice Manager?
TIRislaa
"Uri Dimant" <urid@.iscar.co.il> skrev i melding
news:uwr%23rK5XFHA.3864@.TK2MSFTNGP10.phx.gbl...
> Hi
> BACKUP/ and DBCC SHRINKFILE if you want to reduce a physical size of the
> file
> "Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
> news:uYMARE5XFHA.3096@.TK2MSFTNGP15.phx.gbl...
>|||Right-click the database, All Tasks, Backup database. Do a full database
backup first, then the T-Log
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
news:OaFq8O5XFHA.2520@.TK2MSFTNGP09.phx.gbl...
>I am a bit new to administrating an sql server. How to backup the
>transaction log trough the Enterprice Manager?
> TIRislaa
> "Uri Dimant" <urid@.iscar.co.il> skrev i melding
> news:uwr%23rK5XFHA.3864@.TK2MSFTNGP10.phx.gbl...
>|||hi,
transaction log is very important for your database
read about log in SQL server books online - "How to create a transaction
log backup (Enterprise Manager)"
"Tor Inge Rislaa" wrote:

> I am a bit new to administrating an sql server. How to backup the
> transaction log trough the Enterprice Manager?
> TIRislaa
> "Uri Dimant" <urid@.iscar.co.il> skrev i melding
> news:uwr%23rK5XFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
>|||Back it up: BACKUP LOG
If you don't require log backups then set the Simple recovery model to
minimize transaction log usage.
David Portas
SQL Server MVP
--|||When trying to backup the transaction log I get an error telling me that the
backup log is terminating abnormaly (status = 112), any ideas?
TIRislaa
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> skrev i melding
news:enyGpT5XFHA.2796@.TK2MSFTNGP09.phx.gbl...
> Right-click the database, All Tasks, Backup database. Do a full database
> backup first, then the T-Log
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
> news:OaFq8O5XFHA.2520@.TK2MSFTNGP09.phx.gbl...
>|||Do you have sufficient space to on your destination drive to write a file
the same size as your transaction log?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
news:uIziBn5XFHA.1660@.TK2MSFTNGP10.phx.gbl...
> When trying to backup the transaction log I get an error telling me that
> the backup log is terminating abnormaly (status = 112), any ideas?
> TIRislaa
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> skrev i melding
> news:enyGpT5XFHA.2796@.TK2MSFTNGP09.phx.gbl...
>|||NET HELPMSG 112 displays "There is not enough space on the disk". Ensure
your backup disk has enough space.
Hope this helps.
Dan Guzman
SQL Server MVP
"Tor Inge Rislaa" <tor.ingenospam@.rislaa.no> wrote in message
news:uIziBn5XFHA.1660@.TK2MSFTNGP10.phx.gbl...
> When trying to backup the transaction log I get an error telling me that
> the backup log is terminating abnormaly (status = 112), any ideas?
> TIRislaa
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> skrev i melding
> news:enyGpT5XFHA.2796@.TK2MSFTNGP09.phx.gbl...
>