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
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
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.
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.
Mike Epprecht, Microsoft SQL Server MVP
MVP Program: http://www.microsoft.com/mvp
"Phil" <email@example.com> wrote in message
> They're not encrypted - there...logging question #4
This is a multipart message in MIME format.
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 (firstname.lastname@example.org) 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
Erland Sommarskog, SQL Server MVP, email@example.com
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
...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 (firstname.lastname@example.org) 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, email@example.com
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
"Erland Sommarskog" <firstname.lastname@example.org> wrote in message
> lark (email@example.com) writes:
>> how do i find out what process could have caused a transaction log to
>> 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
Thanks in advance.
> 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
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:
DataPro (firstname.lastname@example.org) 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
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
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
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
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
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
...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.
Posted via a free Usenet account from http://www.teranews.com
> 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.
email@example.com (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 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
"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" <firstname.lastname@example.org> wrote in message
> 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
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
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
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
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?
Is your update statistics script runing update stats on all your databases?
If so, that would explain the syslogs growth in your model db.
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
"Achieve Support" <email@example.com> wrote in message
> 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:
On Fri, 29 Oct 2004 15:50:37 +1300, Jared Forbes
> I would definitely be interested in a potential answer for this as
>well, highly useful.
>df ss wrote:
>>Is there a way to keep the parts log information where has "warning"
or "error" message only?
>>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
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
Or is there a chance to realise something similar like this tikz
terminal in the current gnuplot version? I have not fully understand
Kind regards and thank you for your advice.
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
> 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.
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?
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
>411 if member_i ne lag(member_i) then group=1;
>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
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
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
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 ;
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
...Re: question about SAS Log and email #4
>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:
>Subject: TEST 5.6 ~
>So according to the log, all of the emails were sent, but none of the
>after the @ email were received. I checked with the email server people
>there is no record of the missing emails.
>I just discovered this, which means that over the last several months, I
>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
>Invalid route address
>ERROR: Bad email address: somename@firstname.lastname@example.org
>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.
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
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.
"mokles" <email@example.com> wrote in message
> 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.
www.Paltalk.com: Welcome to the ms access database programmer Group =
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR>
<P><FONT face=3DArial>www.<A =
href=3D"http://Paltalk.com">Paltalk.com</A>: Welcome to=20
the ms access database programmer Group =
...Track the User logged in the Shared MS Access Database
is there a way to know which user last logged in the shared Access
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.
HOW TO: Check Who Logged into Database with Jet UserRoster in Access
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" <firstname.lastname@example.org> wrote in message
> is there a way to know which user last logged in the shared Access
> 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
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
...Re: Datetime in PROC SQL with SQLSERVER database #4
On Wed, 12 Mar 2008 22:11:52 -0400, Nirmal kumar <lazybone2k@GMAIL.COM> wrote:
>I am using ODBC to connect to the database. Thanks
Then your questions are really for SQL SERVER experts rather than SAS experts.
>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
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: CLI open cursor error: [Microsoft][ODBC SQL Server Driver][SQL
> overflow error converting expression to data type smalldatetime.
>Any help on this is really appreciated.
>On 3/12/08, Howard Schreier <hs AT dc-sug DOT org> <
>> On Wed, 12 Mar 2008 18:49:37 -0400, SAS-L Nirmal <lazybone2k@GMAIL.COM>
>> >Hi SAS-Listers,
>> >I have a problem in hand and also I have a solution...Cant create database with > 4 GB log
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
"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.
email@example.com (Pongthai) wrote in message news:<firstname.lastname@example.org>...
> 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
> "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
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
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.
...help MS ACCESS\SAS, general database questions
Hi to all,
I need some help deciding on the best database system for our
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:
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