DPM transaction logs truncation on SQL Server

Hi

I use DPM for backup my SQL Server 2005 and MS Exchange 2007.

When implementing backup Exchange transaction logs is truncated, but when 
SQL Server is not happening and I have to delete logs manually. Why?
How do I configure DPM, to SQL logs were cut, too?

-- 

---------------------------
wishes
Dmitry 

0
Dmitry
11/10/2009 4:21:06 AM
dataprotectionmanager 1083 articles. 0 followers. Follow

3 Replies
10881 Views

Similar Articles

[PageSpeed] 15

Hi,

Have you scheduled to take incremental backups for the SQL Server databases? 
Express full backups do not truncate logs. Incremental backups which are 
infact log backups truncate logs.

-- 
Thanks,
Hitesh Sharma [MSFT]
This posting is provided "AS IS" with no warranties, and
confers no rights.

Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm
"Dmitry Chelyshkov" <chell@elorent.com> wrote in message 
news:uxAo$0bYKHA.3712@TK2MSFTNGP06.phx.gbl...
> Hi
>
> I use DPM for backup my SQL Server 2005 and MS Exchange 2007.
>
> When implementing backup Exchange transaction logs is truncated, but when 
> SQL Server is not happening and I have to delete logs manually. Why?
> How do I configure DPM, to SQL logs were cut, too?
>
> -- 
>
> ---------------------------
> wishes
> Dmitry 


-3
Hitesh
11/10/2009 6:00:06 AM
Hitesh,

Thank you for your response as this also answers my question. I have a 
follow-up question. Does this mean that a new DMP log file is created after 
each DPM log backup or does this work like the express full backups and just 
look at byte level changes? 

"Hitesh Sharma[MSFT]" wrote:

> Hi,
> 
> Have you scheduled to take incremental backups for the SQL Server databases? 
> Express full backups do not truncate logs. Incremental backups which are 
> infact log backups truncate logs.
> 
> -- 
> Thanks,
> Hitesh Sharma [MSFT]
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> 
> Use of included script samples are subject to the terms
> specified at http://www.microsoft.com/info/cpyright.htm
> "Dmitry Chelyshkov" <chell@elorent.com> wrote in message 
> news:uxAo$0bYKHA.3712@TK2MSFTNGP06.phx.gbl...
> > Hi
> >
> > I use DPM for backup my SQL Server 2005 and MS Exchange 2007.
> >
> > When implementing backup Exchange transaction logs is truncated, but when 
> > SQL Server is not happening and I have to delete logs manually. Why?
> > How do I configure DPM, to SQL logs were cut, too?
> >
> > -- 
> >
> > ---------------------------
> > wishes
> > Dmitry 
> 
> 
> .
> 
4
Utf
1/11/2010 2:19:01 AM
I have DPM 2010 RC setup backing up SQL Server 2005, as you have suggested, 
with Synchronization taking place every 45 minutes and the express full 
backup once a day.

The problem is that the transaction logs are not being truncated.

Any suggestions?

This is a fresh load of DPM 2010 RC on Server 2008 R2 Standard x64.



"Hitesh Sharma[MSFT]" wrote:

> Hi,
> 
> Have you scheduled to take incremental backups for the SQL Server databases? 
> Express full backups do not truncate logs. Incremental backups which are 
> infact log backups truncate logs.
> 
> -- 
> Thanks,
> Hitesh Sharma [MSFT]
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> 
> Use of included script samples are subject to the terms
> specified at http://www.microsoft.com/info/cpyright.htm
> "Dmitry Chelyshkov" <chell@elorent.com> wrote in message 
> news:uxAo$0bYKHA.3712@TK2MSFTNGP06.phx.gbl...
> > Hi
> >
> > I use DPM for backup my SQL Server 2005 and MS Exchange 2007.
> >
> > When implementing backup Exchange transaction logs is truncated, but when 
> > SQL Server is not happening and I have to delete logs manually. Why?
> > How do I configure DPM, to SQL logs were cut, too?
> >
> > -- 
> >
> > ---------------------------
> > wishes
> > Dmitry 
> 
> 
> .
> 
0
Utf
3/18/2010 4:31:02 PM
Reply:

Similar Artilces:

Lost logs files
Hi I have one Exchange 2003 and I have lost the disk where I had the logs, so know I can't work with Exchange. Could I recreate the logs with a command?. The last backup I have is of the last day, 24 hours. Thanks, 1. First of all make a copy of your edb and stm files jsut if it is required later. 2. Add the logs drive and create the same directory structure and see if the exchange server mounts the database. 3. If not your bet would be to restore the last backup. 4. If you have exchange 2003 restore your database in RSG and run a repair (long process) and then exmerge the new ...

MS Exchange and Server 2003
Hey, At my company we run MS server 2003 and exchange 5.5. I want to send an email with an attachment to about 7500 users. we have IBM blade server with t1 connections. we have distribution list ready to go. What i want to know is that am i taking any chances in crashing the system. will this have any effect on the server. Thanks DJ If it crashes the server, something is seriously wrong with the config. It might slow mail processing slightly, but should work just fine. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (...

Invalid Object Name
I've searched and searched and can not find out how what's wrong with this query or table. Perhaps this should be posted to a SQL forum but I'm not sure. Someone has a database that worked a few days ago and he is now getting an error message: 'Could not execute query; could not find linked table. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Partxxx'. (#208). I know that the employee's security is correct, and when checking the ODBC a 'test successful' message is received. I'm at a loss. I finally did an Access database ...

Merge same transaction #2
I've had transactions that I've placed in my register with detailed info in the memo area only to have the same exact transaction download with no info and unrecognized as the same transaction. Traditionally I've copied and pasted the info into the downloaded transaction and then deleted my transaction. This is a real PAIN... Is there a way to tell Money that these two separate transactions are the SAME transaction and then have it merge them? It works exactly as intended when Money recognizes the transaction that's already in the register and then merges them beautiful...

bcm logging
has anyone noticed the option in the help, 'about' bcm to enable logging for bcm. if i check it it does not stayed check. ...

Cannot enter transactions in Money 2005 on Vista
I'm trying to run Microsoft 2005 on a new Vista computer. After reading the other posts, I now have Version 14.0.50.1105 and I can open my data file, but I can't input any transactions! It says THIS TRANSACTION CANNOT BE ENTERED. The data file is in a subfolder in Documents and it is not READ-ONLY. It used to work in my old XP computer...I'm going crazy. It took me forever just to open the file and I thought it finally worked! Thanks in advance for your help. ...

Microsoft Access and SQL Server
My company is converting from Oracle to SQL Server 2005. My front end is Microsoft Access 2003. In the conversion, they changed our customer and transaction numbers from decimal fields to BigInt. When I do a make table query in Access, those fields change to text as it is my understanding Access does not support BigInt. Am I correct? Many of my applications use a combination of make table and append queries to get the data I need (most of my stuff my run standalone with no network connection). Linking the tables through queries, reports, etc., will not work with inconsistent data ...

CRM with MSDE, not SQL Server 2000
I seem to be reading some conflicting things. I'm trying to install CRM on windows server 2003. Do I need to use sql server 2000 or can I setup msde to work with it as the CRM database? For the CRM Server, only SQL Server 2000 is supported. Frank Lee Workopia, Inc. www.workopia.com "Dr. Silk" wrote: > I seem to be reading some conflicting things. I'm trying to install > CRM on windows server 2003. Do I need to use sql server 2000 or can I > setup msde to work with it as the CRM database? > > And the best way to get that for the smaller offices is v...

SQL Required on SBS2008 STD
I have SBS2008 STD on a 64Bit platform and need to run a management program that requires SQL server. Can I purchase SQL server and possibly use this on the SBS2008 STD platform? Does Microsoft have migration / upgrade software to SBS 2008 PREMIUM ? I have read a blog, that, technically it is possible to migrate from STD to PREMIUM but there are problems with the EULA. The core component that is required is Windows Server 2008. What are the options available to me? Thanks for your advice in advance. -- Jack How many users will need access to SQL? Would SQL 2008 Express (...

DPM2010
Hi, I am trying to let DPM2010 do a BMR Back-up of my physical Domain Controller. Once I am in the modifying protection group and expand my Domain Controller I receive the below message. I am able to create a System state back-up but a BMR will give a inconsistent state, which I am not able to resolve. DPM is unable to enumerate contents in \\?\Volume{9db0a6be-327e-11df-a4f3-806e6f6e6963}\ on the protected computer mer1-srv101.zorg.local. Recycle Bin, System Volume Information folder, non-NTFS volumes, DFS links, CDs, Quorum Disk (for cluster) and other removable media can...

Gantt Bar truncated
Quick search ends in no joy.... I had a fellow scheduler drop buy with a question. He has inherited a Project (2003) file. The task bars in the gantt chart view do not reflect the "start" and "finish" dates in the start and finish column. When the dates are added to each end of the bar in the gantt chart view, the task bar extends from the start date but does not stretch all the way out the planned finish date. I did a cursory view of the file on my way out and there was nothing readily apparent that would be driving this condition. I'm new to MS Project...

Matching up downloaded transactions from bank and credit card acco
Money 2007 Deluxe I automatically download both my bank and credit card transactions. How do I get MONEY to recognize that the "credit card payment" transaction on my bank account matches the identical but opposite "credit" transaction on my credit card account? When I change the downloaded transaction type to "Credit Card Payment : Discover Card Credit Card" in my Bank Account transaction list, I can find no way to tell money to "match the indentical transation in my Discover Card account transactions." Instead, MONEY creates a "new" a...

MSExchangeAL error in event log
I continue to get the error below in event log regarding Exchange. This started when I demoted the DC to standard server which also had Exchange installed on the same machine. Message: The Win32 API call 'DsGetDCNameW' returned error code [0x54b] The specified domain either does not exist or could not be contacted. The service could not be initialized. Make sure that the operating system was installed properly What has happed here and how do I fix it? Is there a wrong domaincontroller listet in the RUS ? "Larry Bird" wrote: > I continue to get the error bel...

Microsoft Project Gateway in Portfolio Server 2007
Hello I have installed Project Server 2007 SP2 with Language Packages SP2, Portfolio Server 2007 with SP2, SQL Server 2005 with SP3. All in one server I have configured the Project Server Gateway with an attribute mapping template. The customs fields that are text and number can sincrhonize OK with Project Server. But the custom fileds that are lookup tables in Project Server can not syncronize with custom fields that are list type in Portfolio Server. I have created simple custom fields with an lookup table but I can´t syncrhonize I dont get any error in event view...

HELP! Exchange 5.5 Log files are filling up fast!
Hello, I have an exchange 5.5 server that is having log file issues - they keep filling up the drive fast! I am seeing a 5mb log file being created in about 30 seconds and processor utilization is 80% above. I am not able to see what is causing this issue. Any ideas would be appreciated... The internet mail service is not hosted on this particular server. Thanks! how large is the drive? how much room do you have left? has this been going on all day? could be a virus or mail loop...any mailboxes growing in size very rapidly? "exadm" <exadm@discussions.microsoft.com&g...

How to specify the url for a server on local network for POST meth
Hi, I am using MSXML in my device driver for sending XML commands to the device acting as server. This device is connected to my local network. How do I specify the url for POST method in the open request. Presently I am using something like following: pIXMLHTTPRequest->open("POST", "http://10.116.26.155", false); where '10.116.26.155' is the IP of the device on the local network. Is this the write way of doing it? If not, how do I achieve the purpose? Your guidance on this would be gratefully acknowledged ASWip wrote: > I am using MSXML in my devi...

Project Server
Hi, I am having trouble with the backup of Project server using DPM. DPM eseems to work well when it comes to the sharepoint content. But i dont seem to be able to backup any of the shared services specific to Project(EPM). I have enables SPprotection. The only way I can backup EPm is via sql backups. I then the an issue on restoration to an alternate DR site. Hope someone can help or has had simillar experiances ...

SQL
Could anyone help with this:- Can this be achieved in a SQL statement other than making physical tables (other than the FromTo table) ? I have one table called auaudit and need one query to select records that have a field called aufrom and a 2nd query to select all records that have a field called auTo A 3rd query would use the results from the above queries to test if field RD in both are not equal. If not equal would put the HD field from query 1 and the HD field from query2 and the data field from query2 into a new table called FromTo And a 4th query would do the same as the 3rd b...

SQL update for Payables manual payment distributions
Hi All Can someone please provide me with a SQL script to update the distributions of a payables manual payment. The correct check amount is already available for each transaction in the manual payments screen. I now want to use the same value (check amount) for each payment and update the related distribution line items. Thanks in advance, I'm being dense here, but I don't understand what you are trying to do. Do you have the manual payments already saved to a batch and you want to set the distribution accounts without having to open the window? If yes, the dis...

Money 2004 downloaded transactions error
Hi I am able to download my bank account transactions to my Money program. But the amount for each transaction in my Money program is shown slightly different to what I am able to see online. The dollar portion of the amount is the same but the cents portion is different. For example if the actual amount is $88.32 then it shows up as $88.03 in the Money program, if the actual amount is $88.38 then it shows up as $88.04 This is the case with all amounts where the cents portion is not 00. It seems to make the first digit of the cents portion as a zero and the second digit as rounded up ...

Error message with Publisher 2007 Catalog Merge to SQL 2005
Hello When I attempt a Catalog Merge to SQL 2005 with Publisher 2007, I get an 'invalid object name' error. Yet, when I use the exact same .odc connection in Excel 2007, the SQL view opens with no problems. Can anyone duplicate this bug and/or have a solution besides load the data into Excel, save it, and reload it into Publisher? Thanks. I can't find too much about this error. Publisher 2003 had merge problems, maybe by reading the fix, it will give you insight. Error message when you use an .odc file to connect to a specific table in a mail merge data source in Office 20...

SMTP communication problem with the recipient's email server
we are using SBS2000, SMTP connector is using ISP smtp relay server. One of our user getting the following error immediately after he pressed his "Send" button from his outlook 2003. He also got the same error when he tried to send to couple different recipient but the rest are ok. The problem only happened to him today. I do not receive any complaint from any other people. There was a SMTP communication problem with the recipient's email server. Please contact your system administrator. <myserver.mydomain.local #5.5.0 smtp;550 Recipient Not Authorised [recipient reject...

error 3061 with insert into sql
i have the following function. Public Function sqltest( ) Dim strSQL As String strSQL = "INSERT INTO [tblEmpOldDA] " & _ "SELECT 1 AS EmpSerialID ," & _ "[tblOldDA].FromDate ," & _ "[tblOldDA].ToDate ," & _ "[tblOldDA].Rate " & _ "FROM [tblOldDA] " CurrentDb.Execute strSQL End Function when i use this query it is throwing runtime error 3061 too few parameters. Expected 1 when i tried this with docomd.runsql, it is asking me for ...

Exchange Server running out of HD space
We have a Windows 2003 standard server that Exchange 2003 standard is running on. It has 2 partition c: 4 gb and d: 29 gb. The os is on C and Exchange is on d. The problem that I have is that C drive has only 200mb left but exchange is runnng fine. 1. What is the best way to handle this situation without having to purchase a new server? 2. Is there a way to backup everything and repartition the drives and than do a restore? Would this be the best solution? Any help would be great. Thanks have you tried moving the pagefile to d as a quick fix "Rob Rudisill" wrote: > We ha...

Public Folder Replication problem between 2 servers
I'm working on this problem for a week, still couldn't resolve it.... Basically public folders between sites don't replicate. I can't see public folders which I create pf on the other server (doesn't work on both ways). Environment: We have 1 exchange organization and 2 Exchange 2003 SP2 Standard Edt. Servers. at different locations. They're connected eachother via Cisco 1721 Cisco Router and Les10. Diagonistic Logging enabled. Internal mailing works between two servers and clients. Using AdsiEdit tool, I looked at the servers if PFs have got email address enabl...