Encryption Of Trasaction Logs

Sep 17, 2007

Is it possible to encrypt the transaction log during log shipping? How?

View 4 Replies


ADVERTISEMENT

Compress Trasaction Logs (LOG SHIPPING )

Jan 29, 2008



hi

If wanted to set up Logshipping between two sqlserver 2005 enterprise edition servers.The transaction log backup is being taken every 2 hours and with approx size of 1GB - 1.5 GB.
Now before the copy job runs,i want to compress the tlog file on primary server,copy it to secondary server and uncompress it on secondary and then apply transaction logs to secondary server.I need the procedure how to do it.Please help out.

Thx in advance

Regards
Arvind

View 3 Replies View Related

SQL Trasaction Log Question

Dec 14, 2005

How can I read the log file (*.trn) ?

I would like to read all the transactions that were made.

Regards
Manuel Rodrigues

View 1 Replies View Related

SSIS - How Do I Force A Package To Be In One Trasaction?

Sep 12, 2006

Hi,

I want to force a package to work as one transaction so that when one part or container fails, the whole package fails.

Does someone know how to do this?

Thanks,

Ishai.

View 4 Replies View Related

DB Engine :: Write Logs To Windows Event Logs?

Aug 6, 2015

OS: Windows 2012 Enterprise

SQL Server: 2012 Enterprise

I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log. 

View 3 Replies View Related

SQL Security :: Encryption 2005 - User Defined Function For Encryption And Decryption

Oct 7, 2015

I have created two user defined functions for encryption and decryption using passphrase mechanism. When I call encryption function, each time I am getting the different values for the same input. While I searching a particular value, it takes long time to retrieve due to calling decryption function for each row.

best way to encrypt and decrypt using user defined functions.Below is the query which is taking long time.

SELECT ID FROM table WITH (NOLOCK)
                     WHERE dbo.DecodeFunction(column) = 'value'

When I try to use symetric or asymetric encryption, I am not able to put "OPEN SYMETRIC KEY" code in a function. So, I am using PassPhrase mechanism.

View 3 Replies View Related

SSIS Logs Vs Custom Logs Components

Feb 12, 2007

Hi,

In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error.

Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though.

Now what will a custom log provider help me to do in this case. Also can I somehow configure my package to call the send mail task everytime an error is raised.

Also, one more option can be developing a package that only does the error handling. It will take in the paramters or the error codes and descriptions, the destination to write to and a flag to send mail or not for that particular type of error.

What do you think? Kindly advise.

Thanks in advance for your help and time.

Regards,

$wapnil

View 3 Replies View Related

SQL Server Logs (error Logs)

Aug 28, 2001

When looking at SQL Server error logs, I noticed that the current error
log had grown to 1MB whereas most of the files are only a few KB.

QUESTION 1: Can I set the max size for an error log file? If so, how?

QUESTION 2: If not, is there a workaround?

Thanks

View 1 Replies View Related

Logs Are Getting To Big

Aug 4, 1998

the logs on our database keep locking up and return and file size of 0. Does any know of a way to dump the log file. I tried: Dump Transaction log to .... but it did not want to work any ideas.

View 6 Replies View Related

No Logs

Jan 26, 2008

I'm running a SQL Server 2005 Express installation.
Now I notice that the SQL Server logs (under Management in Mgmt Studio Express) are
empty - no logs are in there, neither under Current, nor under the "archived".
Do I have to switch on logging explicitly??
(I'm logging on as "sa".)

View 2 Replies View Related

Performance And Logs

Aug 27, 2006

Hi,I'm using SQL Server Management Studio Express and I have made a website that uses a database with stored procedures.When running pages in my webpages it cost around 2 seconds to load each page.Thanks too long!! But where is the problem???I like to see a list of all executed stored procedures with there execute time (for each page).In this way I can check if the problem is here.How can I get a logfile like this?Thanks!

View 1 Replies View Related

Transaction Logs

Apr 24, 2002

What is the best way to clear the transaction logs. My backup job each night is ending because it says it is running out of disk space and I need to clear up the transaction logs. Any help is appreciated. I see many different options (trucate option, auto shrink, etc.), just need some assistance tosome more specific best approaches. Thanks

View 3 Replies View Related

Please Help....backing Up Trn Logs

Aug 26, 2002

Scenario:

I have August22 full backup and August22 and August23 transactions log backups . I want to get the August23 and August23 full backup. So I performed a restore backup with August22 full backup and all the August22 trn backups. Then I backed up giving it August23 name and repeated the process with the August23 trn backups. But, I get an error saying that the transactions haven't been rolled foward far enough. But, I am not missing any trns! I will really be grateful if anyone would help.
thanks.

View 1 Replies View Related

Transaction Logs

Aug 13, 2001

Im having issues truncating my transaction logs. I have logs in excess of 40 gigs. All the info in the BOL is very vague. Any assistance would be apreciated.

Regards

SeTi Ni

View 5 Replies View Related

Transaction Logs

Jun 22, 2000

When we backup the transaction log,will it truncate the log or it will grow from there?Truncate log on check point is desabled.
Thanks!

View 2 Replies View Related

Alert When Sa Logs In

Sep 19, 2000

Currently, my client is allowing all the developers to log in as sa and most servers have a NULL sa password. Not a good idea. I am recommending them to move to integrated security with NT groups and to move away from using the sa login altogether. Then to secure the sa login, actually give it a password (something cryptic). I also wanted to set up an alert whenever someone logs in using the sa password. How can that be accomplished? A trigger on the sysprocesses table would work but seems a little risky.

View 8 Replies View Related

DTS Error Logs.

Mar 9, 2000

I am currently trying to export from SQL to notes via NotesSQL.I have set up the necessary ODBC data sources & DTS job. I am encountering errors when I attempt to execute the DTS package . I.e "job failed"
- How do I drill down to aquire more detailed error logging on the package to find out exactly what's wrong with DTS?

Thanks

Paul

View 1 Replies View Related

Backup And Logs

May 1, 2000

I've truncated and shrunk the database and now, it says that the size of the db is 14 mb and 8mb is free. However, on the file system, the mdb and
ldb files together adds up to 14 mb. How can I free up the 8 mb for other usage?

Thanks,
Anthony

View 1 Replies View Related

SQL Server Logs

Jan 3, 2001

In Enterprise Manager, Management and then SQL Server Logs, when I clicked on Current or Archive#1 or 2 etc, nothing happens. This has been going on for the past 3 weeks does any one knows what is causing such problems?

View 1 Replies View Related

Error Logs

Oct 3, 2000

When I'm in EM, there is one log that when I click on it to view it hangs my EM. All other logs (current and others) I can click and view just fine. I'm on my way out to the server to see the log in the file directory but what could cause this?

Thanks..

View 2 Replies View Related

Transaction Logs

Aug 30, 2000

to take the transaction log back up regularly I should have truncate log on check point false. If I do so then how will I truncate the log.
regards,
Renu

View 3 Replies View Related

Disable Logs

Aug 28, 2000

Is there a way to disable logging ?
I'm about to split a 1000000 rows table into three other tables , and would prefere not to log this action ...
Does anyone know how to do it in a SQL 7.0 statement ?

View 1 Replies View Related

Transaction Logs

Aug 20, 1998

I am trying to import records via bcp (about 1,500,000 records) and I keep running out of disk space. Is there any way to limit or do away with the transaction log (and still be able to import)?

View 2 Replies View Related

SQL Error Logs

Apr 18, 2000

Is there another way to restart the SQL Error Log without shutting down and restarting the MSSQLserver service?

View 2 Replies View Related

Help On Backup Of Logs

Feb 21, 2001

Help on Backup of Logs
I get the following errors when I am trying to backup log every 15 minutes. It fails only during the peak hours.Does anyone have any ideas why it happens.


Cannot allow BACKUP LOG because file 'XX_data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup. [SQLSTATE 42000] (Error 4213) Backup or restore operation terminating abnormally. [SQLSTATE 4200

View 2 Replies View Related

What Is The Best Way To Truncate The Logs

Dec 24, 2002

I want to have the Transaction logs truncate on checkpoint what is the best way to do this, I take a complete backup everynight of the database. Wouldnt this set a checkpoint and clear the logs? If so it doesn't do that for me.

View 3 Replies View Related

Transaction Logs Help!!!!!!!!!

Dec 14, 1999

how do i decrease the transaction log example 500mb to 100mb, can you help me with the syntax pls!!

View 1 Replies View Related

Transaction Logs

Sep 2, 2004

I need to move transaction logs to a different drive and am looking for a way to do it without detaching the db.

Can I create a second transaction log file for the DB and then delete the original log file?

What is the best way to do this for db's that are being replicated?

Thanks,
Ken Nicholson

View 3 Replies View Related

Shrinking Logs When Still In-use

Apr 15, 2005

Hi, my log has grown out of proportion after performing an indexdefrag in bulk-logged mode!
Now I cant shrink the damn thing coz I have forgotton how to shrink it when the logical log files are still in use.


Can somebody enlighten me please. thankyou.

error msg: "
Cannot shrink log file 2 (MyDatabase_Log) because all logical log files are in use."

View 5 Replies View Related

Tansaction Logs

Jul 22, 1999

Is it normal for database response times to slow down as the transaction log fills up. I have noticed that once it gets above 65% our clients response time through the web slows down? Any suggestions on how to fix this?

View 1 Replies View Related

SQL Server Logs

Nov 9, 2006

Is there any way we can log in the info like this in SQL Server

Who logged in
What date
OS Name
Ipaddress
SQL Login Name

View 2 Replies View Related

Moving T-logs

Mar 7, 2002

Please share any experience and/or suggestions on moving the T-logs to a separate physical drive. What I have read so far suggests that the best way is to sp_detach, physically copy (not move) the logs, and then sp_attach again.. but some questions are unanswered.

For some reason, everything I've found has you copying both .mdf and .ldf files to the new drive... I guess that was just an oversight on the part of the individuals who wrote the documents.. can't imagine wanting to copy the .mdf files too.

When you sp_attach, must you specify the original location for the .mdf files as well as the new location for the .ldf files? Do you have to go into server properties, Database settings/ and change the location of 'default log directory' manually?

Is there any easier way to move the T-logs?

JJones

View 2 Replies View Related

Transaction Logs

Jun 13, 2002

I need to seperate my SMS data files and transaction logs onto two seperate drives. Can anyone assist me with this?

thanks...

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved