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
8433 Views

Similar Articles

[PageSpeed] 7

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 


-2
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 
> 
> 
> .
> 
3
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:

What about DPM 2010 Rc
Anyone use 2010 RC in a production environment? I've put it on a VM to look at it, and it would be nice to use it in production. My Number 1 Reason To Upgrade >>> Can Disable Daily Tape Backups for Saturday and Sunday What's your reason(s) for upgrading? How is it working out for you? Yes. 6 protection groups, 10 servers, 20 vms on a 6 node hyper-v cluster with csv. Runs great. A few quirks here and there but overall great. A far cry from our last backup solution. I basically set it and forget it. Check it when I get in to the office in the morning. ...

Split Transactions & MSN Money Plus
I use Microsoft Money Plus, which was package with MSN.com. I'm just getting started. My question is how are split transactions handled? I use a money card to pay for groceries and often get cash at the same time. For budget purposesI would like to keep these two items in separate categories. Any suggestions? ...

please help; lost credit card transactions
my register went offline yesterday because of a networking problem, at the end of the day I tried to run an x report but the computer said that I was not able to do this on an offline database. I closed the pos program and reopend it online. I understand that at this time is when it should have said that the databases where going to synchronize but it did not say that it opened as it normally would and showed a total sales of what we had sold prior to going offline. I have the receipts for the sales that we did and the cash recipts are not a problem, the problem is all of the credit c...

CRM Uninstall and move to new server
Not realizing that CRM was not compatible with windows 2003 server I built a windows 2003 CRM machine. As it does not work properly I am moving it to a new server. Currently we have no data in the CRM system so no concerns of loosing information. However i am wanting this to go as smoothly as possible. Please comment on the following steps. 1. Uninstall CRM from server 2. Delete databases and OU (IS THIS STEP NEEDED) 3. Build new server with same name 4. Reinstall CRM. Any assistance would be greatly appreciated. River Cox River, You should be able to install MSCRM on the new server...

Delete all transactions
Is there a quick way to delete all the transactions from an account in Money 2004? Other than deleting the account, I don't know one. -- Michael Gordon MVP "C Tate" <colin@nobodyhere.mrcrtate.fsnet.co.uk> wrote in message news:%23XO04PjeEHA.1656@TK2MSFTNGP09.phx.gbl... > Is there a quick way to delete all the transactions from an account in > Money > 2004? > > ...

Analysis Cubes SQL 2005 server
Hi there I have installed Analysis Cubes SQL 2005 firstly without SP2 and then with SP2. The install is successful and I created a job to run daily at 3am. I tested the job by executing it manually and it run without any problems. It runs for 5 companies including TWO. When I analyse the data in the GPDynamcisWarehouse tables, all the data for all the companies exist in the GLAccountMaster, but in the sales tables it shows only the TWO data. Why does this happen Regards Robin ...

calling sql loader from vba
I have a access application front-end with an oracle back end (odbc) On a daily basis we have to import a large text file into one of the Oracle tables. We do this by using the sql loader utility. I have created a controlfile for this I have two requests for help. First: Please could somebody help me with some vba code to launch the sql loader exe (which is on the local drive) with this ctl file as its parameter from a button in a form in the access application. Second: when the sql loader program will launch, a dos box is shown by it showing its load progress. It will close itself ...

DCM for DPM 2007 and DPM 2010
Does anyone know if a DCM pack is available for DPM 2007 and DPM 2010? If you are looking for System center configuration management pack for DPM 2007 and DPM 2010 they are available for DPM health monitoring. If you want DPM 2010 Management pack please mail me at praveend-at-microsoft-dot-com. The closest answer to DCM pack for DPM would be DPM's Best practice analyzer guidelines which can be downloadable from DPM sites. Thanks, Praveen D [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights. "John H" <JohnH@di...

Money 2005 Deluxe account balance error/hidden transactions
To all, As others who have posted before me, I have discovered an error in the home page balance of my AMEX account and the register balance. The transaction report showed 4 hidden transactions in 2006 (I haven't archived '06 yet), all which were originally scheduled bill payments, but did not allow me to edit/void them (amounts "grayed out.") I ran multiple salvage/repair file actions, and the hidden transactions have in fact disappeared. BUT, my home page balance and the register balance still show the discrepancy. This same discrepancy shows when I adjust my view in t...

Create a receivable transaction from payables entry
Is there a module or 3rd party product that will automatically create a receviables entry when I create a payables entry. We need this for reimburable expenses. (i.e. and Amex payable for airfare would generate a receivable from the customer that was visited) ...

Receiving Transaction Error
When trying to receive an item, I am getting the below error: Item's vendor record doesn't exist. The vendor record is in the pm00200 table and it shows on the PO. Hi TBrooks, I would guess the record is missing from IV00103, the Item Vendor Master. Set one up in Cards>Inventory>Vendor and you should be able to post the receipt. Kind regards, Leslie "TBrooks" wrote: > When trying to receive an item, I am getting the below error: > > Item's vendor record doesn't exist. > > The vendor record is in the pm00200 t...

Offline Credit card transaction
I need help with POS 2.0. I need to run an offline charge with the original approval code. is there anyone who will help me without asking for $800.00? ...

New Server Setup Project Plan
I am looking for a project plan to install Great Plains 7.5 on a brand new Windows 2000 server and move data from existing server to the new server. I've done a couple migrations. There are some script tricks to help transfer logins etc. Tell me this first: What version of SQL Server is on the old server? What version of Great Plains? Are you going from like to like, or do you have upgrades to accomplish as well? "Shariq" wrote: > I am looking for a project plan to install Great Plains 7.5 on a brand new > Windows 2000 server and move data from existing server t...

2000 server with BES rebooting and also rebooting 2003 exchange
I work for a company with 5 servers. I'm having a problem with 2 servers in particular. Let's call them server1 and server2, server1 is the exchange 2003 server running Server2003 and server2 is a BES server running on Server2000. About 4 months ago server2 started rebooting unexpectedly, sometimes every night sometimes it will not reboot for as long as 4 days. Everytime it reboots it also reboots server1 (exchange server). My 1st thought was the BB server. 4 days ago I stopped the BB services and sure enough yesterday it rebooted and rebooted server1. I've checked ...

Applying Payables Transaction to Receivables Invoice
I have an invoice in receivables, and I would like to apply a payables document against it. This customer sent us an invoice, and he had one outstanding invoice from us, so he paid us for the difference between these invoices. When I go to apply the payment, I would like to first apply the payables document against the customer invoice so the payment can clear properly. Is this possible? -- I am running on Dynamics GP 10.0, unless otherwise stated. On Oct 2, 8:19=A0am, Orion Cochrane <OrionCochr...@discussions.microsoft.com> wrote: > I have an invoice in receivables, and I woul...

DPM Console crash
Hi there, In our DPM setup we have a created a filter to disable the weekend back-up. It was working fine till a couple of weeks a go. Now when we want to change the date in the filter the DPM console crashes. Does anyone has a solution for this problem? Witch errlog should we troubleshoot Regards, MihaiM Hi MihaiM, You can look at the error logs for UI at: DPM Install location \ temp. Paste the error logs excerpt about exception here or send the error logs to MUKULS [AT] MICROSOFT [DOT] COM -- Thanks and Regards Mukul This posting is provided "AS IS&...

Terminal Server #2
Hi, I have recently installled GP10.0 at a client we have noticed some worrying performance issues when attempting to log into GP with a user that is not an admnistrator. The performace issue starts when clicking the GP icon. It can take as long as three minutes to get to the user login screen. (Enough time to make a cup a coffee). Once you are in GP the performance is OK with some exceptions. This certainly feels like a networking/security/actve directory issue, dont even know how to begin trouble shooting. We cant simply add teh user into the domain or local adminstrator group. An...

IM10 and GL Transaction import limited to 9 entries
Hi, I am on IM10 SP3 and have setup a GL Transaction integration. It works great for the 1st 9 transactions but there after it just creates journals with no account distributions. If I limit my source to no more than 9 transactions then they all work fine - so I do not think it can be the data. Any ideas - this is a problem for us that needs urgent resolve. Thank you Neil ...

multiple OWA web sites on single server?
Hello, I would like to know if it's possible to have multiple OWA web sites on a single server. Reason I need to know is that we would like to use RSA's securid for OWA but not everyone that uses OWA will be using securid. So I would like to have 2 OWA websites, one using securid and the other not. We are using Exchange 2003 server. Thanks! FC You can have 2 web sites on the same server by 1) using the same ip address but different ports 2) using different ip address and default ports (http 80 or https 443) or 3) same ip address and ports, but using different fqdns as host...

Backing up CCR Passive node with DPM (block level)?
Hello Please check the link from the technet forums I posted. http://social.technet.microsoft.com/Forums/en-GB/exchangesvravailabilityandisasterrecovery/thread/fb88bed7-c024-4585-b58d-a8ef58176fc4 Suggested to check out the new threads instead. Basically there is an option in DPM to always choose the passive node in a CCR cluster. I've heard there is a problem though where a consistency check is required and it can transfer up to 90% of the data. Why is DPM doing a block level? Isnt it easier to just check the log files and the database files instead? I'm not an exper...

Safe Pay Transaction Type
I have successfully installed Safe Pay and, while setting up a "Bank Format", am instructed to set up "Transaction Types" for Check and Void. The documentation gives no indication what should be entered here, and I have tried "CHK" and "6" (the document type for a check in the database) to no avail. Without this, I get the message "There is no check transaction type setup. Upload aborted" in a dialog box. Any suggestions? Thanks, -dn The bank should offer some guidance on what codes they want you to use. If they don&...

Matching Transactions between Downloaded and Manually/Automatically Entered Transactions
I statement is updated automatically. Between updates I generally enter transactions since my last update with the merchant's name, amount, category, etc. This generates duplicate transactions in money during a subsequent update. Is it possible for Money to match the transactions that I've entered manually with those received through the automatic update process? This also causes a problem with scheduled bills that are entered automatically. I recall 2004 had such functionality. Kind regards, Orlanzo ...

In case this group is gone from MS News Server
If you are still using MS News Server, please click at the link below in case MS removes this group from their server. MS is in the process of removing groups in favor of using their forums, but they are not going to create a forum for VB Classic, so use the following links instead: news://news.aioe.org/microsoft.public.vb.general.discussion news://news.aioe.org/comp.lang.basic.visual.misc The above news server is free and doesn't require registration. Thanks! I'm curious, what's freedomcrowsnest.org all about? -- "Nobody" <nobody@nobody....

Sql question 05-17-07
Hi all. I have a table (tblStoreInv) with these fields: Index, Store, Product, Quantity. A form (SetInventory) that is connected to that table has these fields: StoreID, Product, Squantity. Only one record is allowed per store, product, Squantity. So here is what I wrote: Private Sub Squantity_BeforeUpdate(Cancel As Integer) Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Set db = CurrentDb strSQL = "SELECT [Quantity],[Store],[Product] FROM tblStoreInv WHERE FORMS![SetInventory]![StoreID]=Store AND FORMS![SetInventory]![Product]=Product AND FORMS![SetInve...

Posting Sales Batch Sending Itemized Transactions to GL
We are having an issue with one cash account where when posting a sales batch sends itemized transaction totals to the GL instead of a total amount for the batch. It was working fine up until a few days ago and I'm not sure if anything changed. Everyone I ask says they didn't do anything. Does anyone know how to make the transaction totals for the batch post as a lump sum instead of itemized? Thanks, Eric Eric: That's a setting in Posting Setup. Tools>Setup>Posting>Posting. Create a Journal Entry per Transaction or Batch. Frank Hamelly MCP-GP, MCT, MVP East ...