f



4 Transaction Log questions

1) Can one find the location of the 'Transaction Log' at: <Hard
Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?

2) Is it safe to delete it, as SQL will create a new Transaction Log when it
realises none already exist?

3) When trying to do 2) I get error message that file is in use, even though
SQL Server is closed. Any suggestions?

4) Can anyone shed light on the error message 'Write on ... <my path
here>... failed, status = 112. BACKUP LOG is terminating abnormally'? I get
this when trying to manually backup the Transaction Log 'All Tasks - Backup'


Thanks for any replies to my ignorance.



0
tzoner (8)
6/25/2003 7:43:30 AM
comp.databases.ms-sqlserver 14567 articles. 1 followers. janinepelletier (108) is leader. Post Follow

9 Replies
449 Views

Similar Articles

[PageSpeed] 43

See inline:
"TZoner" <tzoner@hotmail.com> wrote in message
news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> 1) Can one find the location of the 'Transaction Log' at: <Hard
> Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?
I am not sure what you are asking but sp_helpfile will give the names and
locations of the files associated with a current database.
>
> 2) Is it safe to delete it, as SQL will create a new Transaction Log when
it
> realises none already exist?
I would not recommend deleting any logfile. If SQLServer is running then you
won't be able to as the file is locked. If you have detatched the database
or SQL Server is not running, you may have problems re-attaching the
database or connecting to it once SQL Server is running.

>
> 3) When trying to do 2) I get error message that file is in use, even
though
> SQL Server is closed. Any suggestions?
I doubt if you have stopped the service, but in any case you should not be
deleting it.
If all you want to do is move the file then check out
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

If you want to shrink it check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da2_1uzr.asp

>
> 4) Can anyone shed light on the error message 'Write on ... <my path
> here>... failed, status = 112. BACKUP LOG is terminating abnormally'? I
get
> this when trying to manually backup the Transaction Log 'All Tasks -
Backup'
I don't know what this error is, at a guess there is a lack of disk space.
Maybe there is more information in the SQL Server log file or in the Event
log. You will also get errors if you backup to a mapped network drive.

John
>
>
> Thanks for any replies to my ignorance.
>
>
>


0
6/25/2003 8:15:51 AM
John, thanks for the valuable information.

Where is the 'Transaction Log' located?  I can't find the answer sp_helpfile
or after endless searches on google.

Does a Transaction Log exist per database in SQL Server? When backup occurs,
does these Transaction Log shrink?















"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> See inline:
> "TZoner" <tzoner@hotmail.com> wrote in message
> news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > 1) Can one find the location of the 'Transaction Log' at: <Hard
> > Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?
> I am not sure what you are asking but sp_helpfile will give the names and
> locations of the files associated with a current database.
> >
> > 2) Is it safe to delete it, as SQL will create a new Transaction Log
when
> it
> > realises none already exist?
> I would not recommend deleting any logfile. If SQLServer is running then
you
> won't be able to as the file is locked. If you have detatched the database
> or SQL Server is not running, you may have problems re-attaching the
> database or connecting to it once SQL Server is running.
>
> >
> > 3) When trying to do 2) I get error message that file is in use, even
> though
> > SQL Server is closed. Any suggestions?
> I doubt if you have stopped the service, but in any case you should not be
> deleting it.
> If all you want to do is move the file then check out
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
>
> If you want to shrink it check out
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> ar_da2_1uzr.asp
>
> >
> > 4) Can anyone shed light on the error message 'Write on ... <my path
> > here>... failed, status = 112. BACKUP LOG is terminating abnormally'? I
> get
> > this when trying to manually backup the Transaction Log 'All Tasks -
> Backup'
> I don't know what this error is, at a guess there is a lack of disk space.
> Maybe there is more information in the SQL Server log file or in the Event
> log. You will also get errors if you backup to a mapped network drive.
>
> John
> >
> >
> > Thanks for any replies to my ignorance.
> >
> >
> >
>
>


0
tzoner (8)
6/25/2003 11:02:21 AM
Your transction logs are held in the ldf file which sp_help would give e.g
for Northwind you would get something like:

Name               FileId filename    filegroup Size Maxsize Growth Usage
Northwind                1 E:\MSSQL\DATA\northwnd.mdf PRIMARY 3008 KB
Unlimited 10% data only
Northwind_log         2 E:\MSSQL\DATA\northwnd.ldf NULL 1024 KB Unlimited
10% log only

Northwind_log is the internal logical name for the Transaction Log file
located at E:\MSSQL\DATA\northwnd.ldf. The log only usage shows it is a log
file.

The log file will not automatically shrink on backup, see the link I posted
in the last reply regarding how to shrink it.

John

"TZoner" <tzoner@hotmail.com> wrote in message
news:3ef9813b$0$31280$afc38c87@news.optusnet.com.au...
> John, thanks for the valuable information.
>
> Where is the 'Transaction Log' located?  I can't find the answer
sp_helpfile
> or after endless searches on google.
>
> Does a Transaction Log exist per database in SQL Server? When backup
occurs,
> does these Transaction Log shrink?
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> > See inline:
> > "TZoner" <tzoner@hotmail.com> wrote in message
> > news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > > 1) Can one find the location of the 'Transaction Log' at: <Hard
> > > Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?
> > I am not sure what you are asking but sp_helpfile will give the names
and
> > locations of the files associated with a current database.
> > >
> > > 2) Is it safe to delete it, as SQL will create a new Transaction Log
> when
> > it
> > > realises none already exist?
> > I would not recommend deleting any logfile. If SQLServer is running then
> you
> > won't be able to as the file is locked. If you have detatched the
database
> > or SQL Server is not running, you may have problems re-attaching the
> > database or connecting to it once SQL Server is running.
> >
> > >
> > > 3) When trying to do 2) I get error message that file is in use, even
> > though
> > > SQL Server is closed. Any suggestions?
> > I doubt if you have stopped the service, but in any case you should not
be
> > deleting it.
> > If all you want to do is move the file then check out
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> >
> > If you want to shrink it check out
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> > ar_da2_1uzr.asp
> >
> > >
> > > 4) Can anyone shed light on the error message 'Write on ... <my path
> > > here>... failed, status = 112. BACKUP LOG is terminating abnormally'?
I
> > get
> > > this when trying to manually backup the Transaction Log 'All Tasks -
> > Backup'
> > I don't know what this error is, at a guess there is a lack of disk
space.
> > Maybe there is more information in the SQL Server log file or in the
Event
> > log. You will also get errors if you backup to a mapped network drive.
> >
> > John
> > >
> > >
> > > Thanks for any replies to my ignorance.
> > >
> > >
> > >
> >
> >
>
>


0
6/25/2003 11:58:04 AM
John you've nearly solved my dilemma!!

As per your excellent like I was able to work out that running the 2
following lines will reduce the Transaction File back to it's size!!!
Hooray!!

BACKUP LOG MyDb WITH TRUNCATE_ONLY
DBCC SHRINKFILE (MyDb_log)

However, because MyDb has it's Transaction File full, hence I can't execute
the above two lines. How do I run these commands when MyDb won't let me do
anything to it? To test that the two commands worked I created a dummy MyDb,
grew its Transaction File then executed the two lines and it worked 100%.

Thank you so much for your suggestions!













"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3ef98e4f$0$10627$ed9e5944@reading.news.pipex.net...
> Your transction logs are held in the ldf file which sp_help would give e.g
> for Northwind you would get something like:
>
> Name               FileId filename    filegroup Size Maxsize Growth Usage
> Northwind                1 E:\MSSQL\DATA\northwnd.mdf PRIMARY 3008 KB
> Unlimited 10% data only
> Northwind_log         2 E:\MSSQL\DATA\northwnd.ldf NULL 1024 KB Unlimited
> 10% log only
>
> Northwind_log is the internal logical name for the Transaction Log file
> located at E:\MSSQL\DATA\northwnd.ldf. The log only usage shows it is a
log
> file.
>
> The log file will not automatically shrink on backup, see the link I
posted
> in the last reply regarding how to shrink it.
>
> John
>
> "TZoner" <tzoner@hotmail.com> wrote in message
> news:3ef9813b$0$31280$afc38c87@news.optusnet.com.au...
> > John, thanks for the valuable information.
> >
> > Where is the 'Transaction Log' located?  I can't find the answer
> sp_helpfile
> > or after endless searches on google.
> >
> > Does a Transaction Log exist per database in SQL Server? When backup
> occurs,
> > does these Transaction Log shrink?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> > > See inline:
> > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > > > 1) Can one find the location of the 'Transaction Log' at: <Hard
> > > > Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?
> > > I am not sure what you are asking but sp_helpfile will give the names
> and
> > > locations of the files associated with a current database.
> > > >
> > > > 2) Is it safe to delete it, as SQL will create a new Transaction Log
> > when
> > > it
> > > > realises none already exist?
> > > I would not recommend deleting any logfile. If SQLServer is running
then
> > you
> > > won't be able to as the file is locked. If you have detatched the
> database
> > > or SQL Server is not running, you may have problems re-attaching the
> > > database or connecting to it once SQL Server is running.
> > >
> > > >
> > > > 3) When trying to do 2) I get error message that file is in use,
even
> > > though
> > > > SQL Server is closed. Any suggestions?
> > > I doubt if you have stopped the service, but in any case you should
not
> be
> > > deleting it.
> > > If all you want to do is move the file then check out
> > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> > >
> > > If you want to shrink it check out
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> > > ar_da2_1uzr.asp
> > >
> > > >
> > > > 4) Can anyone shed light on the error message 'Write on ... <my path
> > > > here>... failed, status = 112. BACKUP LOG is terminating
abnormally'?
> I
> > > get
> > > > this when trying to manually backup the Transaction Log 'All Tasks -
> > > Backup'
> > > I don't know what this error is, at a guess there is a lack of disk
> space.
> > > Maybe there is more information in the SQL Server log file or in the
> Event
> > > log. You will also get errors if you backup to a mapped network drive.
> > >
> > > John
> > > >
> > > >
> > > > Thanks for any replies to my ignorance.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
tzoner (8)
6/25/2003 1:36:55 PM
Hi

I am not sure what you mean by not work. As in the link previously posted,
if you last virtual log is in use the file will not shrink


"TZoner" <tzoner@hotmail.com> wrote in message
news:3ef9a575$0$31280$afc38c87@news.optusnet.com.au...
> John you've nearly solved my dilemma!!
>
> As per your excellent like I was able to work out that running the 2
> following lines will reduce the Transaction File back to it's size!!!
> Hooray!!
>
> BACKUP LOG MyDb WITH TRUNCATE_ONLY
> DBCC SHRINKFILE (MyDb_log)
>
> However, because MyDb has it's Transaction File full, hence I can't
execute
> the above two lines. How do I run these commands when MyDb won't let me do
> anything to it? To test that the two commands worked I created a dummy
MyDb,
> grew its Transaction File then executed the two lines and it worked 100%.
>
> Thank you so much for your suggestions!
>
>
>
>
>
>
>
>
>
>
>
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:3ef98e4f$0$10627$ed9e5944@reading.news.pipex.net...
> > Your transction logs are held in the ldf file which sp_help would give
e.g
> > for Northwind you would get something like:
> >
> > Name               FileId filename    filegroup Size Maxsize Growth
Usage
> > Northwind                1 E:\MSSQL\DATA\northwnd.mdf PRIMARY 3008 KB
> > Unlimited 10% data only
> > Northwind_log         2 E:\MSSQL\DATA\northwnd.ldf NULL 1024 KB
Unlimited
> > 10% log only
> >
> > Northwind_log is the internal logical name for the Transaction Log file
> > located at E:\MSSQL\DATA\northwnd.ldf. The log only usage shows it is a
> log
> > file.
> >
> > The log file will not automatically shrink on backup, see the link I
> posted
> > in the last reply regarding how to shrink it.
> >
> > John
> >
> > "TZoner" <tzoner@hotmail.com> wrote in message
> > news:3ef9813b$0$31280$afc38c87@news.optusnet.com.au...
> > > John, thanks for the valuable information.
> > >
> > > Where is the 'Transaction Log' located?  I can't find the answer
> > sp_helpfile
> > > or after endless searches on google.
> > >
> > > Does a Transaction Log exist per database in SQL Server? When backup
> > occurs,
> > > does these Transaction Log shrink?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > > news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> > > > See inline:
> > > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > > news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > > > > 1) Can one find the location of the 'Transaction Log' at: <Hard
> > > > > Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?
> > > > I am not sure what you are asking but sp_helpfile will give the
names
> > and
> > > > locations of the files associated with a current database.
> > > > >
> > > > > 2) Is it safe to delete it, as SQL will create a new Transaction
Log
> > > when
> > > > it
> > > > > realises none already exist?
> > > > I would not recommend deleting any logfile. If SQLServer is running
> then
> > > you
> > > > won't be able to as the file is locked. If you have detatched the
> > database
> > > > or SQL Server is not running, you may have problems re-attaching the
> > > > database or connecting to it once SQL Server is running.
> > > >
> > > > >
> > > > > 3) When trying to do 2) I get error message that file is in use,
> even
> > > > though
> > > > > SQL Server is closed. Any suggestions?
> > > > I doubt if you have stopped the service, but in any case you should
> not
> > be
> > > > deleting it.
> > > > If all you want to do is move the file then check out
> > > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> > > >
> > > > If you want to shrink it check out
> > > >
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> > > > ar_da2_1uzr.asp
> > > >
> > > > >
> > > > > 4) Can anyone shed light on the error message 'Write on ... <my
path
> > > > > here>... failed, status = 112. BACKUP LOG is terminating
> abnormally'?
> > I
> > > > get
> > > > > this when trying to manually backup the Transaction Log 'All
Tasks -
> > > > Backup'
> > > > I don't know what this error is, at a guess there is a lack of disk
> > space.
> > > > Maybe there is more information in the SQL Server log file or in the
> > Event
> > > > log. You will also get errors if you backup to a mapped network
drive.
> > > >
> > > > John
> > > > >
> > > > >
> > > > > Thanks for any replies to my ignorance.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
6/25/2003 2:03:41 PM
Hi

I am not sure what you mean by the transaction log being full. It would
normally wrap around or expand if you have the disk space.

What does DBCC SQLPERF(LOGSPACE) say?

Have you looked at the output from DBCC OPENTRAN (    'database_name'  )?

You may want to look at:
http://www.support.microsoft.com/?id=256650
http://support.microsoft.com/default.aspx?scid=kb;EN-US;110139
http://support.microsoft.com/default.aspx?scid=kb;EN-US;62866

John

"TZoner" <tzoner@hotmail.com> wrote in message
news:3ef9a575$0$31280$afc38c87@news.optusnet.com.au...
> John you've nearly solved my dilemma!!
>
> As per your excellent like I was able to work out that running the 2
> following lines will reduce the Transaction File back to it's size!!!
> Hooray!!
>
> BACKUP LOG MyDb WITH TRUNCATE_ONLY
> DBCC SHRINKFILE (MyDb_log)
>
> However, because MyDb has it's Transaction File full, hence I can't
execute
> the above two lines. How do I run these commands when MyDb won't let me do
> anything to it? To test that the two commands worked I created a dummy
MyDb,
> grew its Transaction File then executed the two lines and it worked 100%.
>
> Thank you so much for your suggestions!
>
>
>
>
>
>
>
>
>
>
>
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:3ef98e4f$0$10627$ed9e5944@reading.news.pipex.net...
> > Your transction logs are held in the ldf file which sp_help would give
e.g
> > for Northwind you would get something like:
> >
> > Name               FileId filename    filegroup Size Maxsize Growth
Usage
> > Northwind                1 E:\MSSQL\DATA\northwnd.mdf PRIMARY 3008 KB
> > Unlimited 10% data only
> > Northwind_log         2 E:\MSSQL\DATA\northwnd.ldf NULL 1024 KB
Unlimited
> > 10% log only
> >
> > Northwind_log is the internal logical name for the Transaction Log file
> > located at E:\MSSQL\DATA\northwnd.ldf. The log only usage shows it is a
> log
> > file.
> >
> > The log file will not automatically shrink on backup, see the link I
> posted
> > in the last reply regarding how to shrink it.
> >
> > John
> >
> > "TZoner" <tzoner@hotmail.com> wrote in message
> > news:3ef9813b$0$31280$afc38c87@news.optusnet.com.au...
> > > John, thanks for the valuable information.
> > >
> > > Where is the 'Transaction Log' located?  I can't find the answer
> > sp_helpfile
> > > or after endless searches on google.
> > >
> > > Does a Transaction Log exist per database in SQL Server? When backup
> > occurs,
> > > does these Transaction Log shrink?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > > news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> > > > See inline:
> > > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > > news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > > > > 1) Can one find the location of the 'Transaction Log' at: <Hard
> > > > > Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?
> > > > I am not sure what you are asking but sp_helpfile will give the
names
> > and
> > > > locations of the files associated with a current database.
> > > > >
> > > > > 2) Is it safe to delete it, as SQL will create a new Transaction
Log
> > > when
> > > > it
> > > > > realises none already exist?
> > > > I would not recommend deleting any logfile. If SQLServer is running
> then
> > > you
> > > > won't be able to as the file is locked. If you have detatched the
> > database
> > > > or SQL Server is not running, you may have problems re-attaching the
> > > > database or connecting to it once SQL Server is running.
> > > >
> > > > >
> > > > > 3) When trying to do 2) I get error message that file is in use,
> even
> > > > though
> > > > > SQL Server is closed. Any suggestions?
> > > > I doubt if you have stopped the service, but in any case you should
> not
> > be
> > > > deleting it.
> > > > If all you want to do is move the file then check out
> > > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> > > >
> > > > If you want to shrink it check out
> > > >
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> > > > ar_da2_1uzr.asp
> > > >
> > > > >
> > > > > 4) Can anyone shed light on the error message 'Write on ... <my
path
> > > > > here>... failed, status = 112. BACKUP LOG is terminating
> abnormally'?
> > I
> > > > get
> > > > > this when trying to manually backup the Transaction Log 'All
Tasks -
> > > > Backup'
> > > > I don't know what this error is, at a guess there is a lack of disk
> > space.
> > > > Maybe there is more information in the SQL Server log file or in the
> > Event
> > > > log. You will also get errors if you backup to a mapped network
drive.
> > > >
> > > > John
> > > > >
> > > > >
> > > > > Thanks for any replies to my ignorance.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
6/25/2003 2:14:41 PM
John

BACKUP LOG MyDb WITH TRUNCATE_ONLY
DBCC SHRINKFILE (MyDb_log)

If a Transaction File has grown from originally 1Mb to 100Mb, executing the
above 2 lines in a stored procedure will shrink that Transaction File to as
close to 1Mb as possible. This is exactly what I urgently need to do.
However, if the Transaction File is full, hence I'm prevented from running
the stored procedure, how do I execute these 2 lines of code against MyDb?
I've tried using the Query Analyser. Line 1 executes correctly. However line
2 causes the error "Server: Msg 8985, Level 16, State 1, Line 1. Could not
locate file 'MyDb_Log' in sysfiles". I've manually verified that MyDb_Log
does indeed exist in the sysfiles table of MyDb.

Any suggestions?











"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3ef9abc1$0$10629$ed9e5944@reading.news.pipex.net...
> Hi
>
> I am not sure what you mean by not work. As in the link previously posted,
> if you last virtual log is in use the file will not shrink
>
>
> "TZoner" <tzoner@hotmail.com> wrote in message
> news:3ef9a575$0$31280$afc38c87@news.optusnet.com.au...
> > John you've nearly solved my dilemma!!
> >
> > As per your excellent like I was able to work out that running the 2
> > following lines will reduce the Transaction File back to it's size!!!
> > Hooray!!
> >
> > BACKUP LOG MyDb WITH TRUNCATE_ONLY
> > DBCC SHRINKFILE (MyDb_log)
> >
> > However, because MyDb has it's Transaction File full, hence I can't
> execute
> > the above two lines. How do I run these commands when MyDb won't let me
do
> > anything to it? To test that the two commands worked I created a dummy
> MyDb,
> > grew its Transaction File then executed the two lines and it worked
100%.
> >
> > Thank you so much for your suggestions!
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > news:3ef98e4f$0$10627$ed9e5944@reading.news.pipex.net...
> > > Your transction logs are held in the ldf file which sp_help would give
> e.g
> > > for Northwind you would get something like:
> > >
> > > Name               FileId filename    filegroup Size Maxsize Growth
> Usage
> > > Northwind                1 E:\MSSQL\DATA\northwnd.mdf PRIMARY 3008 KB
> > > Unlimited 10% data only
> > > Northwind_log         2 E:\MSSQL\DATA\northwnd.ldf NULL 1024 KB
> Unlimited
> > > 10% log only
> > >
> > > Northwind_log is the internal logical name for the Transaction Log
file
> > > located at E:\MSSQL\DATA\northwnd.ldf. The log only usage shows it is
a
> > log
> > > file.
> > >
> > > The log file will not automatically shrink on backup, see the link I
> > posted
> > > in the last reply regarding how to shrink it.
> > >
> > > John
> > >
> > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > news:3ef9813b$0$31280$afc38c87@news.optusnet.com.au...
> > > > John, thanks for the valuable information.
> > > >
> > > > Where is the 'Transaction Log' located?  I can't find the answer
> > > sp_helpfile
> > > > or after endless searches on google.
> > > >
> > > > Does a Transaction Log exist per database in SQL Server? When backup
> > > occurs,
> > > > does these Transaction Log shrink?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > > > news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> > > > > See inline:
> > > > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > > > news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > > > > > 1) Can one find the location of the 'Transaction Log' at: <Hard
> > > > > > Disk>\Program Files\Microsoft SQL
Server\MSSQL\Data\MyDb_Log.ldf?
> > > > > I am not sure what you are asking but sp_helpfile will give the
> names
> > > and
> > > > > locations of the files associated with a current database.
> > > > > >
> > > > > > 2) Is it safe to delete it, as SQL will create a new Transaction

> Log
> > > > when
> > > > > it
> > > > > > realises none already exist?
> > > > > I would not recommend deleting any logfile. If SQLServer is
running
> > then
> > > > you
> > > > > won't be able to as the file is locked. If you have detatched the
> > > database
> > > > > or SQL Server is not running, you may have problems re-attaching
the
> > > > > database or connecting to it once SQL Server is running.
> > > > >
> > > > > >
> > > > > > 3) When trying to do 2) I get error message that file is in use,
> > even
> > > > > though
> > > > > > SQL Server is closed. Any suggestions?
> > > > > I doubt if you have stopped the service, but in any case you
should
> > not
> > > be
> > > > > deleting it.
> > > > > If all you want to do is move the file then check out
> > > > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> > > > >
> > > > > If you want to shrink it check out
> > > > >
> > > >
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> > > > > ar_da2_1uzr.asp
> > > > >
> > > > > >
> > > > > > 4) Can anyone shed light on the error message 'Write on ... <my
> path
> > > > > > here>... failed, status = 112. BACKUP LOG is terminating
> > abnormally'?
> > > I
> > > > > get
> > > > > > this when trying to manually backup the Transaction Log 'All
> Tasks -
> > > > > Backup'
> > > > > I don't know what this error is, at a guess there is a lack of
disk
> > > space.
> > > > > Maybe there is more information in the SQL Server log file or in
the
> > > Event
> > > > > log. You will also get errors if you backup to a mapped network
> drive.
> > > > >
> > > > > John
> > > > > >
> > > > > >
> > > > > > Thanks for any replies to my ignorance.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
tzoner (8)
6/25/2003 2:16:37 PM
Ooops!!!


"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3ef9abc1$0$10629$ed9e5944@reading.news.pipex.net...
> Hi
>
> I am not sure what you mean by not work. As in the link previously posted,
> if you last virtual log is in use the file will not shrink
>
>
> "TZoner" <tzoner@hotmail.com> wrote in message
> news:3ef9a575$0$31280$afc38c87@news.optusnet.com.au...
> > John you've nearly solved my dilemma!!
> >
> > As per your excellent like I was able to work out that running the 2
> > following lines will reduce the Transaction File back to it's size!!!
> > Hooray!!
> >
> > BACKUP LOG MyDb WITH TRUNCATE_ONLY
> > DBCC SHRINKFILE (MyDb_log)
> >
> > However, because MyDb has it's Transaction File full, hence I can't
> execute
> > the above two lines. How do I run these commands when MyDb won't let me
do
> > anything to it? To test that the two commands worked I created a dummy
> MyDb,
> > grew its Transaction File then executed the two lines and it worked
100%.
> >
> > Thank you so much for your suggestions!
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > news:3ef98e4f$0$10627$ed9e5944@reading.news.pipex.net...
> > > Your transction logs are held in the ldf file which sp_help would give
> e.g
> > > for Northwind you would get something like:
> > >
> > > Name               FileId filename    filegroup Size Maxsize Growth
> Usage
> > > Northwind                1 E:\MSSQL\DATA\northwnd.mdf PRIMARY 3008 KB
> > > Unlimited 10% data only
> > > Northwind_log         2 E:\MSSQL\DATA\northwnd.ldf NULL 1024 KB
> Unlimited
> > > 10% log only
> > >
> > > Northwind_log is the internal logical name for the Transaction Log
file
> > > located at E:\MSSQL\DATA\northwnd.ldf. The log only usage shows it is
a
> > log
> > > file.
> > >
> > > The log file will not automatically shrink on backup, see the link I
> > posted
> > > in the last reply regarding how to shrink it.
> > >
> > > John
> > >
> > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > news:3ef9813b$0$31280$afc38c87@news.optusnet.com.au...
> > > > John, thanks for the valuable information.
> > > >
> > > > Where is the 'Transaction Log' located?  I can't find the answer
> > > sp_helpfile
> > > > or after endless searches on google.
> > > >
> > > > Does a Transaction Log exist per database in SQL Server? When backup
> > > occurs,
> > > > does these Transaction Log shrink?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > > > news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> > > > > See inline:
> > > > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > > > news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > > > > > 1) Can one find the location of the 'Transaction Log' at: <Hard
> > > > > > Disk>\Program Files\Microsoft SQL
Server\MSSQL\Data\MyDb_Log.ldf?
> > > > > I am not sure what you are asking but sp_helpfile will give the
> names
> > > and
> > > > > locations of the files associated with a current database.
> > > > > >
> > > > > > 2) Is it safe to delete it, as SQL will create a new Transaction
> Log
> > > > when
> > > > > it
> > > > > > realises none already exist?
> > > > > I would not recommend deleting any logfile. If SQLServer is
running
> > then
> > > > you
> > > > > won't be able to as the file is locked. If you have detatched the
> > > database
> > > > > or SQL Server is not running, you may have problems re-attaching
the
> > > > > database or connecting to it once SQL Server is running.
> > > > >
> > > > > >
> > > > > > 3) When trying to do 2) I get error message that file is in use,
> > even
> > > > > though
> > > > > > SQL Server is closed. Any suggestions?
> > > > > I doubt if you have stopped the service, but in any case you
should
> > not
> > > be
> > > > > deleting it.
> > > > > If all you want to do is move the file then check out
> > > > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> > > > >
> > > > > If you want to shrink it check out
> > > > >
> > > >
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> > > > > ar_da2_1uzr.asp
> > > > >
> > > > > >
> > > > > > 4) Can anyone shed light on the error message 'Write on ... <my
> path
> > > > > > here>... failed, status = 112. BACKUP LOG is terminating
> > abnormally'?
> > > I
> > > > > get
> > > > > > this when trying to manually backup the Transaction Log 'All
> Tasks -
> > > > > Backup'
> > > > > I don't know what this error is, at a guess there is a lack of
disk
> > > space.
> > > > > Maybe there is more information in the SQL Server log file or in
the
> > > Event
> > > > > log. You will also get errors if you backup to a mapped network
> drive.
> > > > >
> > > > > John
> > > > > >
> > > > > >
> > > > > > Thanks for any replies to my ignorance.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
6/25/2003 2:19:36 PM
Hi

Try using the file id instead of the logical file name.

sp_helpfile will give your bother the logical name and the file id.

John

"TZoner" <tzoner@hotmail.com> wrote in message
news:3ef9aec4$0$31274$afc38c87@news.optusnet.com.au...
> John
>
> BACKUP LOG MyDb WITH TRUNCATE_ONLY
> DBCC SHRINKFILE (MyDb_log)
>
> If a Transaction File has grown from originally 1Mb to 100Mb, executing
the
> above 2 lines in a stored procedure will shrink that Transaction File to
as
> close to 1Mb as possible. This is exactly what I urgently need to do.
> However, if the Transaction File is full, hence I'm prevented from running
> the stored procedure, how do I execute these 2 lines of code against MyDb?
> I've tried using the Query Analyser. Line 1 executes correctly. However
line
> 2 causes the error "Server: Msg 8985, Level 16, State 1, Line 1. Could not
> locate file 'MyDb_Log' in sysfiles". I've manually verified that MyDb_Log
> does indeed exist in the sysfiles table of MyDb.
>
> Any suggestions?
>
>
>
>
>
>
>
>
>
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:3ef9abc1$0$10629$ed9e5944@reading.news.pipex.net...
> > Hi
> >
> > I am not sure what you mean by not work. As in the link previously
posted,
> > if you last virtual log is in use the file will not shrink
> >
> >
> > "TZoner" <tzoner@hotmail.com> wrote in message
> > news:3ef9a575$0$31280$afc38c87@news.optusnet.com.au...
> > > John you've nearly solved my dilemma!!
> > >
> > > As per your excellent like I was able to work out that running the 2
> > > following lines will reduce the Transaction File back to it's size!!!
> > > Hooray!!
> > >
> > > BACKUP LOG MyDb WITH TRUNCATE_ONLY
> > > DBCC SHRINKFILE (MyDb_log)
> > >
> > > However, because MyDb has it's Transaction File full, hence I can't
> > execute
> > > the above two lines. How do I run these commands when MyDb won't let
me
> do
> > > anything to it? To test that the two commands worked I created a dummy
> > MyDb,
> > > grew its Transaction File then executed the two lines and it worked
> 100%.
> > >
> > > Thank you so much for your suggestions!
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > > news:3ef98e4f$0$10627$ed9e5944@reading.news.pipex.net...
> > > > Your transction logs are held in the ldf file which sp_help would
give
> > e.g
> > > > for Northwind you would get something like:
> > > >
> > > > Name               FileId filename    filegroup Size Maxsize Growth
> > Usage
> > > > Northwind                1 E:\MSSQL\DATA\northwnd.mdf PRIMARY 3008
KB
> > > > Unlimited 10% data only
> > > > Northwind_log         2 E:\MSSQL\DATA\northwnd.ldf NULL 1024 KB
> > Unlimited
> > > > 10% log only
> > > >
> > > > Northwind_log is the internal logical name for the Transaction Log
> file
> > > > located at E:\MSSQL\DATA\northwnd.ldf. The log only usage shows it
is
> a
> > > log
> > > > file.
> > > >
> > > > The log file will not automatically shrink on backup, see the link I
> > > posted
> > > > in the last reply regarding how to shrink it.
> > > >
> > > > John
> > > >
> > > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > > news:3ef9813b$0$31280$afc38c87@news.optusnet.com.au...
> > > > > John, thanks for the valuable information.
> > > > >
> > > > > Where is the 'Transaction Log' located?  I can't find the answer
> > > > sp_helpfile
> > > > > or after endless searches on google.
> > > > >
> > > > > Does a Transaction Log exist per database in SQL Server? When
backup
> > > > occurs,
> > > > > does these Transaction Log shrink?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > > > > news:3ef95a3b$0$18495$ed9e5944@reading.news.pipex.net...
> > > > > > See inline:
> > > > > > "TZoner" <tzoner@hotmail.com> wrote in message
> > > > > > news:3ef952a0$0$31277$afc38c87@news.optusnet.com.au...
> > > > > > > 1) Can one find the location of the 'Transaction Log' at:
<Hard
> > > > > > > Disk>\Program Files\Microsoft SQL
> Server\MSSQL\Data\MyDb_Log.ldf?
> > > > > > I am not sure what you are asking but sp_helpfile will give the
> > names
> > > > and
> > > > > > locations of the files associated with a current database.
> > > > > > >
> > > > > > > 2) Is it safe to delete it, as SQL will create a new
Transaction
>
> > Log
> > > > > when
> > > > > > it
> > > > > > > realises none already exist?
> > > > > > I would not recommend deleting any logfile. If SQLServer is
> running
> > > then
> > > > > you
> > > > > > won't be able to as the file is locked. If you have detatched
the
> > > > database
> > > > > > or SQL Server is not running, you may have problems re-attaching
> the
> > > > > > database or connecting to it once SQL Server is running.
> > > > > >
> > > > > > >
> > > > > > > 3) When trying to do 2) I get error message that file is in
use,
> > > even
> > > > > > though
> > > > > > > SQL Server is closed. Any suggestions?
> > > > > > I doubt if you have stopped the service, but in any case you
> should
> > > not
> > > > be
> > > > > > deleting it.
> > > > > > If all you want to do is move the file then check out
> > > > > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> > > > > >
> > > > > > If you want to shrink it check out
> > > > > >
> > > > >
> > > >
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> > > > > > ar_da2_1uzr.asp
> > > > > >
> > > > > > >
> > > > > > > 4) Can anyone shed light on the error message 'Write on ...
<my
> > path
> > > > > > > here>... failed, status = 112. BACKUP LOG is terminating
> > > abnormally'?
> > > > I
> > > > > > get
> > > > > > > this when trying to manually backup the Transaction Log 'All
> > Tasks -
> > > > > > Backup'
> > > > > > I don't know what this error is, at a guess there is a lack of
> disk
> > > > space.
> > > > > > Maybe there is more information in the SQL Server log file or in
> the
> > > > Event
> > > > > > log. You will also get errors if you backup to a mapped network
> > drive.
> > > > > >
> > > > > > John
> > > > > > >
> > > > > > >
> > > > > > > Thanks for any replies to my ignorance.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
6/25/2003 2:34:27 PM
Reply:

Similar Artilces:

Log Shipping Transaction Log Question
I am going through a security audit on our servers. We use log shipping for a standby database. One of the questions in the audit has me looking for answers. "Are the transaction logs that are being shipped to the standby database encrypted?" I am assuming no. However, I need to know definitively. I have not been able to find an answer in BOL or in Google. If the logs are not encrypted, is there an option where I could send them encrypted, if necessary? Thanks, Jennie They're not encrypted - there are a number of 3rd-party products available which can reconstruct SQL commands from reading transaction log files. I'm afraid I have no idea whether or not there is a simple (or even a complex!) way to encrypt/decrypt them, though. Hi If you are worried about encryption over the wire, then you need to do it at network packet level as all your other traffic is sniffable. SQL will not encrypt the files, and if you are using the built-in Log shipping, you can't do it. If you were to roll your own version of log shipping using scripts, you could use a 3rd party tool the encrypt it. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "Phil" <philip.yale@gmail.com> wrote in message news:1113571698.710644.115450@z14g2000cwz.googlegroups.com... > They're not encrypted - there...

logging question #4
This is a multipart message in MIME format. ------=_NextPart_000_0019_01CFB6F0.B4882020 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I posted a question about logger module to create a log file every day. I had a problem recently in logging. My pc restarts regularly. Whenever it restarts I lose all the log since it writes in the file once per day. Is there a way to log information in a file as soon as it available. My application is a tcp server. Before I did it without using logger module, I developed customized lo...

Why does Error log show database restarting everytime a transaction log backup runs?
Why does Error log show database restarting everytime a transaction log backup runs? It also runs a checkdb as well. The log backups are scheduled through a maintenance plan. Is this normal? Sanctus (mchi55@hotmail.com) writes: > Why does Error log show database restarting everytime a transaction > log backup runs? > It also runs a checkdb as well. > > The log backups are scheduled through a maintenance plan. > > Is this normal? Sounds like the maintenance plan includes a CHECKDB that sort of thing as well. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx ...

transaction log #4
how do i find out what process could have caused a transaction log to fill up possibly over hte last 24 or 48 hours? thanks in advance lark (lark@buysurething.com) writes: > how do i find out what process could have caused a transaction log to fill > up possibly over hte last 24 or 48 hours? You can try DBCC LOG and see if you can make some sense of the output. I think the first parameter is the database id, and the second controls the amount of output. Else, you need a log reader. There are a couple on the market. Lumigent have been in that trade the longest. There is also Log PI, and I think ApexSQL has one too. But if your transaction log fills up in 48 hours, you are probably not backing it up often enough. Depending on your recovery needs, once an hour, or every ten minutes may be good choices. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx "Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns9AD55DC3D077Yazorman@127.0.0.1... > lark (lark@buysurething.com) writes: >> how do i find out what process could have caused a transaction log to >> fill >> up possibly over hte last 24 or 48 hours? > > You can try DBCC LOG and see if you can make some sense of the output. > I thi...

Question on Transaction Log Backups
New to Sql Server, running SQL Server 2000. Our transaction log file backups occasionally fail as the size of the transaction log gets really huge. We'd like to schedule additional transaction log backups. Does that require an exclusive on the database or can the db be used during a transaction log backup? Also, does switching to a bulk mode recovery model before a bulk operation then switching back to full recovery mode after present any issues? Thanks in advance. DataPro wrote: > New to Sql Server, running SQL Server 2000. > > Our transaction log file backups occasionally fail as the size of the > transaction log gets really huge. We'd like to schedule additional > transaction log backups. Does that require an exclusive on the database > or can the db be used during a transaction log backup? > > Also, does switching to a bulk mode recovery model before a bulk > operation then switching back to full recovery mode after present any > issues? It doesn't make sense to switch back and forth. You can permanently switch to bulk logged because different logging for bulk operations is all this recovery model is about. See Microsoft's documentation for more details: http://technet2.microsoft.com/WindowsServer/en/Library/1d76e446-3122-4f2d-a696-1e260ae740f91033.mspx?mfr=true Kind regards robert DataPro (datapro01@yahoo.com) writes: > Our transaction log file backups occasionally fail as the size of the > transaction ...

Database Design Question #4
I know this isn't SQL Server specific but I've been pondering over designing a payment system for our existing application which uses SQL Server 2000. We have an application that tracks employees and the companies that they consult for. The employees are in an employee table using an identity column for the primary key called EmployeeID. The companies are in a company table, also using an identity column for its PK called CompanyID. The employees are contracted out to different companies. Each company has different responsibilities for paying some of the wages and benefits of our consultants based on the contract with the employer. Here are the 4 possible scenarios we need to support: 1) Employee makes payment to a Company's account (e.g. reimbursing company for personal phone calls done on company equipment, broken equipment, etc) 2) Employee makes payment to its own account (e.g. personal contribution to retirement fund, health insurance not covered by company contract, etc) 3) Company makes payment to an Employee's account (e.g. health insurance, pension, dental, overtime wages, reimbursements for personal expenses, etc) 4) Company makes payment to its own account (e.g. consulting fees charged by our consulting firm, other services our firm provides the company) A payment can be broken down into the following elements: 1) Identity column for PK 2) The date/time of the payment 3) Who made the payment (Employee or Company) 4) To which account ...

Transaction log and tempdb #4
Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file during the execution of a sql script ? Indeed, my sql script work with very large table and my transaction log file use all the space on my hard drive. so the script have to stop with an error. - Is it possible to limit the size of the database tempdb ? I have an another script sql who do an insert from a select with join (join between 2 table of more that 24 Go) and group by. During the execution of that script, SQL Server freeze, it doesn't progress anymore, and I have to stop my process. So that is it possible that script works with a tempdb database not larger than 24 GO per exemple ? Thanks you in advance for your advice K. ...

Converting database to MS-SQLServer from PostGRESQL
Forgive me if this question is a bit too generic, if it is, feel free to just not respond. I have a database which has been running in PostgreSQL for a number of years at this stage which I want to port into MS SQL server. It seems that the SQL that Postgre outputs when I do a backup is not syntactically correct within MS-SQL server. My question is, does anyone have any documentation on how to convert a database from the Postgre platform to SQL server? Is it possible using an ODBC connection to import a database structure including table definitions, views etc into SQL Server? Failing this, does anyone have any suggestions on where I might start - I did attempt to go through the SQL code and modify it to suit SQL server, but it's about 3,500 lines of code excluding the insert statements (which themselves are also wrong) and almost every line needs something changed when comparing SQL syntax from Postgre to MSSQL server Thanks in advance for any comments/suggestions. Engada. -- Posted via a free Usenet account from http://www.teranews.com Engada wrote: > I have a database which has been running in PostgreSQL for a number of > years at this stage which I want to port into MS SQL server. > > It seems that the SQL that Postgre outputs when I do a backup is not > syntactically correct within MS-SQL server. pg_dump has a number of flags that may help, e.g. --inserts What specific types of syntax errors do you encounter? Googling (Postgr...

ask me a question ms access databases
I will be willing to help, with access databases, in same order request is received. The web site is at www.jaxdatasolutions.com. This is for a limited time only. ivanmendoza@comcast.net (Ivan) wrote: >I will be willing to help, with access databases, in same order >request is received. The web site is at <snipped> This >is for a limited time only. Umm, hows about we ask questions in this newsgroup? Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm "Tony Toews" wrote > > I will be willing to help, with access > > databases, in same order request is > > received. The web site is at <snipped> > > This is for a limited time only. > > Umm, hows about we ask questions > in this newsgroup? Would one of the first ones be "Why ask questions just of a particular, unknown person of unknown ability instead of asking them publicly where they will be seen by many persons of proven ability?" <G> "Ivan" <ivanmendoza@comcast.net> wrote in message news:2be4a61d.0408010952.5f1d1438@posting.google.com... > I will be willing to help, with access databases, in same order > request is received. The web site is at www.jaxdatasolutions.com. This > is for a limited time only. Good idea. ...

Transaction Logs von Berkley Database
Hello, I'm use an Openldap 2.3.11 withe SuSE (Novell) Linux ES 9.1. The backend is a the Berkley Database (Sleepycat) 4.3. The LDBM have'nt enough Performance - to much Datas. Now I have a problem with the BDB. The BDB write to many transaction logfiles (log.xxxxxxxxxx). An delete operation of the logfiles is'nt good, I should use the Berkley Tools to delete old logfiles. But the Berkleytools are functionally only when the Openldap is stopped. But I can't stop the Openldap in the Production. Therefor I have build an DB_CONFIG: set_cachesize 0 10485760 0 set...

Model Database Transaction Log fills up
Has anyone had an instance of the model database transaction log filling up? We recently encountered 2 seperate instances of this happening and just chalked it up to a fluke. However, we have an installed client base of between 400 - 500 Sybase Installations of which we provide maintenance and support to. We have now had numerous instances of the model database tran log filling up. We have verified that no users are assigned to model as their default database. We have verified there are not user tables created in model. What transactions get written to model? Is there anyway to dump the log and read the contents of it to try to determine what is occuring on model? Thank you. Is your update statistics script runing update stats on all your databases? If so, that would explain the syslogs growth in your model db. My recommendations 1) don't run update stats on model 2) 'trunc log on checkpoint' should be true for all model db's 3) when backing up model, make sur you trunc the tran log also If that doesn't help, change model to read only and be done with the problem. Karl "Achieve Support" <melissa.fischer@achievehealthcare.com> wrote in message news:390bcc91.0310010708.1d6460d3@posting.google.com... > Has anyone had an instance of the model database transaction log > filling up? > We recently encountered 2 seperate instances of this happening and > just chalked it up to a fluke. ...

Re: Log Window question #4
Lex Jasen has a very good tool: http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0207b&L=sas-l&D=1&O=D&P=44032 On Fri, 29 Oct 2004 15:50:37 +1300, Jared Forbes <jared.forbes001@MSD.GOVT.NZ> wrote: > I would definitely be interested in a potential answer for this as >well, highly useful. > >:) > >df ss wrote: > >>Hi SAS-L, >>Is there a way to keep the parts log information where has "warning" or "error" message only? >>Thank you >>tggsun >> >> >>--------------------------------- >>Do you Yahoo!? >>Express yourself with Y! Messenger! Free. Download now. >> >> >> > > ------------------------------- > This email message and any attachment(s) is intended only for the > person(s) or entity(entities) to whom it is addressed. The > information it contains may be classified as IN CONFIDENCE and may be > legally privileged. If you are not the intended recipient any use, > disclosure or copying of the message or attachment(s) is strictly > prohibited. If you have received this message in error please > notify us immediately and destroy it and any attachment(s). > Thank you. The Ministry of Social Development accepts no > responsibility for changes made to this message or to any > attachment(s) after transmission from the Ministry. > ------------------------------- ...

Question about gnuplot 4.4.3 and version 4.5
Dear all, I would like to try out gnuplot 4.5 that is currently under development to try out terminal tikz. On the other hand I would like to have a reliable gnuplot version installed. Would this be possible to have both version installed, please, and could you give me advise how this should be done on Mac OSX, please? Or is there a chance to realise something similar like this tikz terminal in the current gnuplot version? I have not fully understand this. Kind regards and thank you for your advice. G. On Sun, 29 May 2011 10:15:42 -0700, G. wrote: > Dear all, > I would like to try out gnuplot 4.5 that is currently under development > to try out terminal tikz. On the other hand I would like to have a > reliable gnuplot version installed. Would this be possible to have both > version installed, please, and could you give me advise how this should > be done on Mac OSX, please? > Or is there a chance to realise something similar like this tikz > terminal in the current gnuplot version? I have not fully understand > this. > Kind regards and thank you for your advice. G. See the item rpm? from Feb 21st. I describe how to build a local version of gnuplot from source. You can then have as many local versions as you want. Assuming that building gnuplot on Mac OSX is similar to building on Linux. Cheers, Peter Dear Peter, I have found your entry. It worked until make. Make stopped with dyld: Library not loaded: ...

Re: question of reading log #4 1551738
you could eliminate the message with retain end_date 0 ; but what is appropriate ? What you are trying to do may be appropriate, but not only SAS is unable to understand it, neither can I ! Would you like to explain ? Would you like to read up on the lag() function in the documentation? Peter On Wed, 15 Feb 2006 14:54:01 -0800, Mindy <master2005_sas@YAHOO.COM> wrote: >I run some program, and get the log as the following: > >406 data elig2; >407 set elig; >408 by member_i begin_da end_date; >409 retain group; >410 if member_i=lag(member_i) and begin_da >lag(end_date)+1 then >group+1; >411 if member_i ne lag(member_i) then group=1; >412 run; > >NOTE: Missing values were generated as a result of performing an >operation on missing values. > Each place is given by: (Number of times) at (Line):(Column). > 1 at 410:55 >NOTE: There were 13571 observations read from the data set WORK.ELIG. >NOTE: The data set WORK.ELIG2 has 13571 observations and 7 variables. >NOTE: DATA statement used: > real time 0.04 seconds > cpu time 0.04 seconds > >My question is why there is a note about Missing Value. I checked all >variables in dataset elig, there is no missing value. Also, I tried to >use retain group(1) instead of retain group, in the above programming, >but still couldn't get ride of the Missing Value note. Does anyone know >the reaso...

Re: a question of the ODS and log window #4
Toby Dunn To sensible men, every day is a day of reckoning. ~John W. Gardner The important thing is this: To be able at any moment to sacrifice that which we are for what we could become. ~Charles DuBois Don't get your knickers in a knot. Nothing is solved and it just makes you walk funny. ~Kathryn Carpenter ljmpll , I am a little confused by your post. ODS changes your output destination not your log destination. Howard already gave you the ODS code to turn off your the output to your output window: ODS Listing Close ; >>Your code here<< ODS Listing ; If you want to turn off the log then you will need: Options Nonotes Nosource NoSource2 ; And to turn it back on: Options Notes Source Source2 ; From: ljmpll@SOHU.COM Reply-To: ljmpll@SOHU.COM To: SAS-L@LISTSERV.UGA.EDU Subject: a question of the ODS and log window Date: Sun, 10 Dec 2006 05:50:19 -0800 When I apply ODS, If I hope that any content would not be in log window of SAS. Then,what code should I write? Thanks!!! _________________________________________________________________ Stay up-to-date with your friends through the Windows Live Spaces friends list. http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mk ...

Re: question about SAS Log and email #4
annhett@GMAIL.COM wrote: > >I've read some related topics, but here is a slightly different situation. > >I attempted to send out a batch of email. One email was just '@xxx.edu'. >This is what the log shows: > >WARNING: Email: 553 5.1.3 <@xxx.edu>... User address required >ERROR: Bad email address: @xxx.edu >WARNING: Email: 503 5.0.0 Need RCPT (recipient). > > >All of the emails after the bad email result in the following log entries: > >Message sent >To: 'somename@uiuc.edu' >Cc: >Bcc: >Subject: TEST 5.6 ~ >Attachments: > >So according to the log, all of the emails were sent, but none of the >emails >after the @ email were received. I checked with the email server people >and >there is no record of the missing emails. > >I just discovered this, which means that over the last several months, I >may >have had thousands of emails not go out, that I thought did because the log >says "message sent". > >Can anything be done about this? Is there a setting I need to change? Is >this how SAS works? > >I just looked through some of my old logs and found other cases: > >WARNING: Email: 553 5.1.3 ><somename@anothername@hotmail.com<somename@anothername@hotmail.com>>... >Invalid route address >ERROR: Bad email address: somename@anothername@hotmail.com ><somename@anothername@hotmail.com> > >If SAS stops sen...

Using Transaction log to update another database
I am doing some replication setup in test environment. Will it be possible to use the transaction log from a production server to update the test server? Any reference to any document will also be appreciated. I know I have to restore most recent backup from the production server to the test server. and all the transactions after the backup on the production server has to be run on the test server. Thanks for your reply. -Mokles Hi I think you are looking for log shipping which can be found in books online. There have also been several articles in SQL Server magazine about writing your own system to ship logs http://www.winnetmag.com/Article/ArticleID/23231/23231.html Log shipping may not be what you should be doing to keep a test server up to date. Periodic restoration of a recent backup may be enough to enable you to investigate any problems with you live system. If the server is being used for pre-release testing or regression testing then you certainly will not required ship logs. John "mokles" <mokles@rogers.com> wrote in message news:Xe43d.18138$RTE1.582@news01.bloor.is.net.cable.rogers.com... > I am doing some replication setup in test environment. Will it be possible > to use the transaction log from a production server to update the test > server? Any reference to any document will also be appreciated. > > I know I have to restore most recent backup from the production server to > the test server. and all the transactions a...

paltalk MS ACCESS, general database questions
This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C7AAE9.97F77F70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable www.Paltalk.com: Welcome to the ms access database programmer Group = unsha ------=_NextPart_000_0007_01C7AAE9.97F77F70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> <P><FONT face=3DArial>www.<A = href=3D"http://Paltalk.com">Paltalk.com</A>: Welcome to=20 the ms access database programmer Group = unsha</FONT></P></DIV></BODY></HTML> ------=_NextPart_000_0007_01C7AAE9.97F77F70-- ...

Track the User logged in the Shared MS Access Database
Hi, is there a way to know which user last logged in the shared Access database. My requirement is that I must be able to track the users that log in the database and incase its not working because one of the user has done something wrong that I must be able to track him/her. TIA -G. See: HOW TO: Check Who Logged into Database with Jet UserRoster in Access 2000 at: http://support.microsoft.com/?id=198755 You may find it easier to use your initialization code (e.g. AutoExec macro) to actually log the users in and out. Just Execute an Append query statement on a table set up for this purpose. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Gaurav" <gaurav_singhal@infosys.com> wrote in message news:97442483.0407080634.4b165940@posting.google.com... > > is there a way to know which user last logged in the shared Access > database. > My requirement is that I must be able to track the users that log in > the database and incase its not working because one of the user has > done something wrong that I must be able to track him/her. ...

export sqlserver database to ms-access by sql script
Hi Is there anyway to export a sqlserver database to ms-access through a sql scipt only without using the sql enterprise manager. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200601/1 ...

Re: Datetime in PROC SQL with SQLSERVER database #4
On Wed, 12 Mar 2008 22:11:52 -0400, Nirmal kumar <lazybone2k@GMAIL.COM> wrote: >Hi all, > >Howard: >I am using ODBC to connect to the database. Thanks Then your questions are really for SQL SERVER experts rather than SAS experts. > >Sigurd: > >I tried using datepart function in the SQL where statement. It says that >datepart function needs to have two arguments and it is invalid with one >argument. The *SAS* DATEPART function uses one argument). But that's irrelevant; you are writing code for SQL SERVER, which apparently has a DATEPART function whose rules you must follow. > >I also converted the date in the macro variable to datetime22.3 function and >then used in the where statement. This is the SAS part: forming a literal which SQL SERVER will understand. >Even then i am getting the following >error. > >ERROR: CLI open cursor error: [Microsoft][ODBC SQL Server Driver][SQL >Server]Arithmetic > overflow error converting expression to data type smalldatetime. > >Any help on this is really appreciated. > >thanks, > >cheers, >Kumar > > > >On 3/12/08, Howard Schreier <hs AT dc-sug DOT org> < >schreier.junk.mail@gmail.com> wrote: >> >> On Wed, 12 Mar 2008 18:49:37 -0400, SAS-L Nirmal <lazybone2k@GMAIL.COM> >> wrote: >> >> >Hi SAS-Listers, >> > >> >I have a problem in hand and also I have a solution...

Cant create database with > 4 GB log
Hi, I got a backup file from my friend which needs 11 GB to hold the transaction log. I tried to restore this database but an error message: "MODIFY FILE encountered operating system error 112(error not found) while attempting to expand the physical file." appeared. The free space is more than enough. I then tried another way to create a database with a 11 gb log file but it fails with the same error message whenever I tried to create any database with a file larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is this the cause of this limitation? p.s. I'm very new to the SQLServer. Pls Help, Will. pongthai@msn.com (Pongthai) wrote in message news:<4bf99b6f.0405042008.9cc4e14@posting.google.com>... > Hi, > > I got a backup file from my friend which needs 11 GB to hold the > transaction log. I tried to restore this database but an error > message: > > "MODIFY FILE encountered operating system error 112(error not found) > while attempting to expand the physical file." > > appeared. The free space is more than enough. I then tried another way > to create a database with a 11 gb log file but it fails with the same > error message whenever I tried to create any database with a file > larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is > this the cause of this limitation? > > p.s. I'm very new to the SQLServer. > > > Pls Help, > Will....

SQL Server 2000 Transaction Log Backup Question
Hi, I've a question regarding the transaction-log backup on SQL-Server 2000. We have implemented a low cost replication. Every evening we make a full backup and beginning at 7 to 18 we make transaction-log backups which are restore (no recovery) to the "standby-server". The full backups are restored every evening. Today i noticed something strange. Yesterday the last transaction log was made at 19 and afterwards applied to the standby server. At 20:30 a full backup was made, but NOT copied to the standby server and hence not aplied there. Starting at 7 this morning the first transactionlog was copied and successfully restored by the standby-server. To my surprise. Because yesterdays full backup wasen't restored at the standby server, just the transaction logs. I thought, if you make a full backup SQL Server "resets" or "destroys" the log-chain. Imagine the following timeline. x-2 -- x-1 -- x -- x+1 -- x+2, where x represents a full backup and the other ones are transactionlog backups. So you can restore x+1 WITHOUT restoring the full backup at x if you have succesfully restored x-1 with no recovery?! Thanks in advance. Bye Florian ...

help MS ACCESS\SAS, general database questions
Hi to all, I need some help deciding on the best database system for our specific application. OPTIONAL INFO: We currently have 2 separate projects that need to be updated from dos-based dBase. I'll only describe one of these but the other is comparable in size. The project currently has about 32 files. The 2 largest are about 30,000 records and 5 columns include data from the last 30 years. The other 30 files are created by year and are about 1000 records and 10 columns. There are only 2 or 3 people keying in data, never at the same time. We also have a sonic digitizer (measures distance between age rings on fish scales) from which data is fed into the dBase form. I think the data transfer program is written in C and the dBase form is written in Clipper. We currently have MS Access and SAS. My suggestion was to design the same type of user entry forms in MS Access and place the files on a shared drive on our network server (already in place and routinely backed up). If the amount of data or number of users increased we could consider going to a database server with Access as the "front end." Most of the analysis is performed in SAS which can readily import Access tables. I was met with some opposition: SAS/ACCESSS/SERVER QUESTIONS: There was a strong objection to using ODBC to get data into SAS (when discussing database servers). Does SAS Import wizard use ODBC? Are there inherent problems with ODBC? Is there any advantage to having data analyze...

Web resources about - 4 Transaction Log questions - comp.databases.ms-sqlserver

Transaction cost - Wikipedia, the free encyclopedia
Bargaining costs are the costs required to come to an acceptable agreement with the other party to the transaction, drawing up an appropriate ...

Mike Schroepfer, Colin Stretch, Mark Zuckerberg Detail Facebook Stock Transactions
... and CEO Mark Zuckerberg submitted Form 4 filings to the Securities and Exchange Commission Wednesday detailing their Facebook stock transactions. ...

Unilever’s charitable app uses Timeline and subscription billing; Facebook agrees to take only 5 percent ...
... this week, including subscription payments and the new Open Graph-enabled Like action . Betapond says Facebook agreed to take a 5 percent transaction ...

Transaction Network Services - LinkedIn
Learn about working at Transaction Network Services. Join LinkedIn today for free. See who you know at Transaction Network Services, leverage ...

New Service Mines 120 Million Consumers' Card Transactions for Marketer Insights
... online to help advertisers target and measure ad campaigns, more companies than ever are creating new revenue streams from offline transactional ...

There's a name for that pang of jealousy you get from seeing people's Venmo transactions
Ever feel inexplicably jealous and sad all because of your friends' Venmo transactions? There's now a name for that reaction. Mic has dubbed ...

Renewables Account For Lion’s Share Of Energy Transactions In 2015
Renewables accounted for the lion’s share of all power and utility transactions during 2015, according to a new report from EY. EY’s new report, ...

Mizuho Bank eyes blockchain to speed international securities transactions
... the type and number of financial instruments being traded, the amount due and the currency used, the country of settlement, and the transaction ...

Apple Pay only makes half as much per transaction in China
Apple Pay may have finally launched in China, but it seems that Apple flinched first in its negotiations with Chinese banks over their adoption ...

Salesforce Shield Activity Monitor Gains Transaction Security Feature
... original Salesforce Shield software monitors unauthorized access to sensitive data, but Salesforce is taking the idea step further with Transaction ...

Resources last updated: 3/22/2016 11:18:58 AM