|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > log file for database is full!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
log file for database is full!
|
|
| George W. Jackson 2002-11-27, 11:23 am |
| Hello to all. I am relatively new to SQL server. I am the Network Admin.
Assist. and my boss, the Network Admin., is on vacation. Today, I come into
work to find out that the D: on our SQL server is full!! If a user tries to
save their time they get this error message:
------------
Microsoft SQL Server: 9002[MIcrosoft][ODBC SQL Server Driver][SQL Server]The
log file for database 'ARTPROD' is full.
Back up the transaction log for the database to free up some log space.
------------
I discovered where the log file and .tmp files for this database where
located (on D and discovered that that drive has no more available free
space.
Does anyone have anykind of suggestions? Anything will do right now. My
Network Admin. is not returning my calls, he might have left town for
Thanksgiving.
Thanks in advance,
George W. Jackson (CNS)
Advanced.1
| |
| chris 2002-11-27, 12:23 pm |
| Read up on Transaction Logs/ truncating / backing up/ amd also dbcc
shrinkfile.
"George W. Jackson" <jacksonbilly@hotmail.com> wrote in message
news:eEidCbjlCHA.1392@tkmsftngp04...
> Hello to all. I am relatively new to SQL server. I am the Network Admin.
> Assist. and my boss, the Network Admin., is on vacation. Today, I come
into
> work to find out that the D: on our SQL server is full!! If a user tries
to
> save their time they get this error message:
> ------------
> Microsoft SQL Server: 9002[MIcrosoft][ODBC SQL Server Driver][SQL
Server]The
> log file for database 'ARTPROD' is full.
> Back up the transaction log for the database to free up some log space.
> ------------
>
> I discovered where the log file and .tmp files for this database where
> located (on D and discovered that that drive has no more available free
> space.
>
> Does anyone have anykind of suggestions? Anything will do right now. My
> Network Admin. is not returning my calls, he might have left town for
> Thanksgiving.
>
> Thanks in advance,
>
> George W. Jackson (CNS)
> Advanced.1
>
>
| |
| Catelin Wang 2002-11-27, 12:23 pm |
| Back up the transaction log.
Right click on the DB--all tasks--backup db -- check transaction
log--specify a file to put the back up--run it.
It should do it.
"George W. Jackson" <jacksonbilly@hotmail.com> wrote in message
news:eEidCbjlCHA.1392@tkmsftngp04...
> Hello to all. I am relatively new to SQL server. I am the Network Admin.
> Assist. and my boss, the Network Admin., is on vacation. Today, I come
into
> work to find out that the D: on our SQL server is full!! If a user tries
to
> save their time they get this error message:
> ------------
> Microsoft SQL Server: 9002[MIcrosoft][ODBC SQL Server Driver][SQL
Server]The
> log file for database 'ARTPROD' is full.
> Back up the transaction log for the database to free up some log space.
> ------------
>
> I discovered where the log file and .tmp files for this database where
> located (on D and discovered that that drive has no more available free
> space.
>
> Does anyone have anykind of suggestions? Anything will do right now. My
> Network Admin. is not returning my calls, he might have left town for
> Thanksgiving.
>
> Thanks in advance,
>
> George W. Jackson (CNS)
> Advanced.1
>
>
| |
| George W. Jackson 2002-11-27, 4:24 pm |
| Thanks for your replies. Well, my network admin. came in for a short time
this afternoon, and we disvored what happened. SQL is doing these backup
jobs everyday. Each one is over a gig in size. They are supposed to be
overwriting themselves but apparently they're not. Anyhow, we deleted all
but the last backup and now the server is fine. Does anyone have any ideas
on where to go to make sure SQL's backup jobs overwrite previous ones?
Thanks again,
George W. Jackson (CNS)
Advanced.1
"George W. Jackson" <jacksonbilly@hotmail.com> wrote in message
news:eEidCbjlCHA.1392@tkmsftngp04...
> Hello to all. I am relatively new to SQL server. I am the Network Admin.
> Assist. and my boss, the Network Admin., is on vacation. Today, I come
into
> work to find out that the D: on our SQL server is full!! If a user tries
to
> save their time they get this error message:
> ------------
> Microsoft SQL Server: 9002[MIcrosoft][ODBC SQL Server Driver][SQL
Server]The
> log file for database 'ARTPROD' is full.
> Back up the transaction log for the database to free up some log space.
> ------------
>
> I discovered where the log file and .tmp files for this database where
> located (on D and discovered that that drive has no more available free
> space.
>
> Does anyone have anykind of suggestions? Anything will do right now. My
> Network Admin. is not returning my calls, he might have left town for
> Thanksgiving.
>
> Thanks in advance,
>
> George W. Jackson (CNS)
> Advanced.1
>
>
| |
| Quentin Ran 2002-11-29, 10:23 am |
| George,
most likely you have a "Maintenance Plan" set which runs the log backup. If
that's the case, make change to that plan and that will take care of it.
In Enterprise Manager, go to your registered server, expand Management,
expand Database Maintenance Plans, find the maintenance plan in question,
double click it, click the Transaction log Backup tab, change the Remove
File Old Than value.
Quentin
"George W. Jackson" <jacksonbilly@hotmail.com> wrote in message
news:eGyqiImlCHA.2032@tkmsftngp02...
> Thanks for your replies. Well, my network admin. came in for a short time
> this afternoon, and we disvored what happened. SQL is doing these backup
> jobs everyday. Each one is over a gig in size. They are supposed to be
> overwriting themselves but apparently they're not. Anyhow, we deleted all
> but the last backup and now the server is fine. Does anyone have any
ideas
> on where to go to make sure SQL's backup jobs overwrite previous ones?
>
> Thanks again,
>
> George W. Jackson (CNS)
> Advanced.1
>
>
> "George W. Jackson" <jacksonbilly@hotmail.com> wrote in message
> news:eEidCbjlCHA.1392@tkmsftngp04...
> > Hello to all. I am relatively new to SQL server. I am the Network
Admin.
> > Assist. and my boss, the Network Admin., is on vacation. Today, I come
> into
> > work to find out that the D: on our SQL server is full!! If a user
tries
> to
> > save their time they get this error message:
> > ------------
> > Microsoft SQL Server: 9002[MIcrosoft][ODBC SQL Server Driver][SQL
> Server]The
> > log file for database 'ARTPROD' is full.
> > Back up the transaction log for the database to free up some log space.
> > ------------
> >
> > I discovered where the log file and .tmp files for this database where
> > located (on D and discovered that that drive has no more available
free
> > space.
> >
> > Does anyone have anykind of suggestions? Anything will do right now.
My
> > Network Admin. is not returning my calls, he might have left town for
> > Thanksgiving.
> >
> > Thanks in advance,
> >
> > George W. Jackson (CNS)
> > Advanced.1
> >
> >
>
>
|
|
|
|
|