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

Similar Articles

[PageSpeed] 54

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:

Setting up Server information
I would like to know how to locate incoming and outgoing mail server information. Another problem I have is knowledge about how many various email account types I can use as I have an email address with yahoo and msn. -- Microsoft questioning "inevitable" <inevitable@discussions.microsoft.com> wrote in message news:3E8A5145-F746-40B1-B40F-48AD423E816E@microsoft.com... >I would like to know how to locate incoming and outgoing mail server > information. Another problem I have is knowledge about how many various > email > account types I can use as I have an ema...

Can MSCRM_CONFIG be renamed (in SQL)?
Question is from one of our customers. I believe not... Just say no. kinda like those t-shirts in the 80s. Dave Ireland "Alex (crm-resultants.nl)" <Alexcrmresultantsnl@discussions.microsoft.com> wrote in message news:BE7200E8-A6FD-468E-ACC1-F33F48A7806D@microsoft.com... > Question is from one of our customers. > I believe not... ...

Foundation and Server
Is Sharepoint Foundation 2010 an essential if I am going to install Sharepoint Server 2010? ...

Disable recall message on the server
Hi, Is there a way to disable or turn off message recall on the server side? I do not care if it still shows up on the users outlook client, but management would like to make it so it never works on our server. We are using Exch 2003 sp1. Thanks, Debra In news:191B223A-D29E-406E-BE23-D378B9647B2A@microsoft.com, Debra <Debra@discussions.microsoft.com> typed: > Hi, > > Is there a way to disable or turn off message recall on the server > side? I do not care if it still shows up on the users outlook > client, but management would like to make it so it never works on...

Server error
Hi all i m sending this request to google server GET http://www.google.com/reader/atom/%s/private/full HTTP/1.0\r \nAuthorization: GoogleLogin auth=%s\r\n\r\n" , strUserName(Usermailid) , strAuthKey(Authtikation key) ); it is giving such kind of Message (The server encountered a temporary error and could not complete your request.<p></p> Please try again in 30 seconds.) So firstly i waited for some time but after waiting such a long time it is giving same kind of Message . one other query if the url is wrong then it gives the same kind of message or somethin...

Outlook Client: Change the On Line Server address
Hi, Is it possible to change the address of the CRM server that the Outlook Client uses to syncronise? -- Thanks in advance Chris Hi Chris, You can make this change by editing the following registry key - HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient\ServerUrl. The usual warning - please be careful while making registry edits! HTH, Niths "BoltonWolf" wrote: > Hi, > > Is it possible to change the address of the CRM server that the Outlook > Client uses to syncronise? > -- > Thanks in advance > Chris Thanks for that, I think that works ok. I'...

Importing Debtor transactions
We are importing debtors transactions into Great Plains. This month it was about 9400 transactions. We import them via Integration Manager (Text files) but it takes more than 8 hours to do. I would like to know of any suggestions of other import facilities to use that can provide a speed benefit. The alternatives I know of is the following: 1. Integration managed but with a ODBC connection to a SQL Server 2. eConnect Any comments are welcome. I had the same issue happen importing 10,000 invoices into the receivables module. I wrote an import that put the data directly into the t...

Outlook not removing deleted messages from server
I have a gmail account and Outlook 2007 is configured to leave the messages on the POP3 server, but to remove the messages from the server when deleted from the "deleted items" folder. So, I downloaded all of my email (approx 17,000 messages), deleted some messages I don't want any more and emptied the "deleted items" folder, but the messages are not removed from the server. I've tried it several times in several different ways, always with the same result. I can delete the local copy on my PC, but the server copy is never removed. "sparx&qu...

Automatic transactions download setup
I would like to set up transaction downloads for an account at a mutual fund brokerage. I have one account with seven different funds. When I tried to add this account for auto downloads, it made each of the funds accounts, and ignored the exsiting account. I have not had this problem with other brokerages. Why on this one? It is American Century. Thanks When you go onto the web site of American Century, does each fund show up under 1 account or under separate accounts? -- Neil "Globfly" <Globfly@discussions.microsoft.com> wrote in message news:BE23B547-5E89-4...

Access 2007 SQL Pass Through Queries
I have an Access 2003 mdb that I use to connect to a SQL 2005 database. When I open the application in Access 2007 it errors on using SQL pass through queries. I see that pass through queries (amongst other options) have been disabled under Access 2007. However it seems that they are enabled under certain circumstances so I've been trying to get them working by changing the security settings. The queries are still failing after setting the following: - Sandbox Mode to 0 (turn off sandbox mode for all apps) - Applied a recognised Digital Signature - Trusted the Publisher - Trusted the loc...

Removing last 5.5 server
We migrated from NT 4.0 and Exchange 5.5 to Win 2003 and Exchange 2003. The ADC was installed to move the mailboxes from the old server to the new one. While the new Exchange server was installed into the new AD domain it was also installed into the old Exchange 5.5 "site". In system manager we have one Administrative Group which shows both servers. If I select the properties from this group it shows the old domain and administrator account. Is this correct? Do I need to be concerned if I remove the old Exchange server? I have followed all of the other instructions from the MS...

Outlook Client on CRM 1.2 Server Box for Demos
Hi, Did a CRM 1.2 install on Windows 2003 Server and all is working well. I have been seeing things on this newsgroup that say I should be able to install the Outlook client as well on this machine although it is an unsupported configuration. This is for demo's only. I am running it under Virtual PC. I would like to not have to have 2 Virtual PC images running just to show the Outlook integration to CRM. When I try to install the Outlook client I get a message at the start saying that the Outlook client is already installed. It is not. Suggestions anyone? Alan ...

Read XML into Dataset and load SQL server table from Dataset
Hello all, I am working on a project with the following characteristics: 1. Load data from a SQL server table to an xml file 2. Read the xml file into a dataset. 3. Load data from the dataset into another SQL server table. I was able to accomplish the first objective. I used the following code to read the generated xml file into a dataset. Dim strXml As String = "C:\Customers.xml" Dim sr As StreamReader = New StreamReader(strXml) Dim ds As DataSet = New DataSet ds.ReadXml(sr, XmlReadMode.IgnoreSchema) How can I traverse in the dataset and post each row to my desired table on ...

PA Cost Categories should allow multiple transaction usage types
When creating new cost categories, in a real life project accounting or job cost environment, most clients don't want all their cost categories to be different. You should be able to say when setting up a cost category that you want that cost category to be able to be used as a Timesheet AND Purchases/Materials, you should be able to pick one or many of the usage types. I currently have a client that had to implement 2 million cost categories to get around this product limitation and there is not one good business reason why the software wouldn't allow this! Please place this...

FTP upload to Server
I'd like to use the Save-On-Close Macro to automatically perform an FTP upload to save the file to my server site. Before I try to write the macro code, I need to figure out how to do it manually. I'm running Excel97 under WinXP. I could probably write (with lots of learning) a .bat file to do the job using a separate FTP application, but then I'd have to install that file on all machines from which file was to be uploaded. The help menu says: On File Menu - Click "Save as" in "save in" box, click internet locations (FTP) [ I only find a comman...

This error in event log
Hi all I do have exch2003 and outlook 2003 I did get this error 4 times today in the event log. I cannot find concrete info on it on how to solve it. Should i ignore it or is it trying to tell me something important : Thanks for ll the help Error 0x6bb deleting unused restricted view from folder 1-D86610 on database "First Storage Group\Mailbox Store (<servername>)". Microsoft Exchange Information Store will try to delete the view again at the next maintenance interval. For more information, click http://www.microsoft.com/contentredirect.asp. http://support.microsof...

how do I set a semi-log plot on Excel
Create your chart. Double click on the vertical axis, and on the scale tab, check the Logarithmic Scale box. If you decide you want a log-log chart, you need to start with a scatter chart, In a scatter chart, both axes offer the Logarithmic Scale option. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ...

VSS and Snapshots/Clones log purging and mixing backup types
I would really appreciate if anyone could answer the following questions for me as we are looking into the use of iSCSI block storage and snapshot technology: 1. Is a snapshot capable of being rolled forward in the event of a DB failure/corruption to provide a no-loss restore in the event of DB corruption? 2. Can a snapshot be mounted into an RSG? 3. Can agent based conventional backups be mixed with VSS backups? 4. If snapshotting is used how are log files purged? 5. As snapshots are deltas are backed up clones required in order to protect from disk failures? The original data needs to b...

DPM 2010 RC
On two test systems the DPRM Service (set to Manual by Default Install) fails to start when called. Resolution: Set to auto start and start the service or Manually start the service. Expected: Would expect that calls from the DPM server would succeed in starting the service. Any idea what could block a DPM server from starting the Service from the DPM server? No firewall or antivirus in the test. -- David Please check the DCOM launch/Activation permissions on the protected server? You can find it by launching dcomcnfg from an elevated command prompt-> ...

MOM 2005 and SQL Server 2005
Hello, I'm not having much luck searching through the knowledge base or the newsgroup to find definate information. What is the current status of trying to run MOM 2005 using SQL Server 2005 instead of SQL Server 2000? Some posts seem to indicate SP1 should allow it to work, even if it's still technically unsupported. Is that the case? Since I'll get charged for another media set from our vendor to get the new MOM SP1 CD since everything I've seen says slipstreaming isn't possible. I'd like to make sure it'll work before I purchase a second copy of the CD set....

sql sp4 to server
If I apply sql 2000 sp4 do I also need to apply sp4 to the desktop engine on my laptop clients using outlook client? I meant to say that If I apply sql sp4 to the CRM server (which is running sql locally) will I also need to aplly sp4 to the MSDE instances on my laptop users PC's using the Outlook client? Sorry just a little anxious\nervous when it comes to CRM 1.2. Trying to get to CRM 3.0 "dstinnett" wrote: > If I apply sql 2000 sp4 do I also need to apply sp4 to the desktop engine on > my laptop clients using outlook client? Yes sp4 is required for the msde. ...

CRM Report erro on SQL server web
Can anyone help out with this --tya Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0006: Metadata file 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll' could not be found Source Error: [No relevant source lines] Source File: Line:...

y label truncated
I have truncated y labels in excel 2000. I have a widescreen laptop and a microsoft technical article says it is a widescreen specific bug. The solution is to change resolution. This doesnt work. What does work is a fullstop several characters after the text which you must make white to stop from showing. Does anyone know if there is a patch for this?. Also, does anyone know if it affects all excel versions including 2003? Thanks to anyone with info ...

Server list blank when launching GP Utilities
We just installed GP 9.0 on a new workstation. When we try to launch GP Utilities, we do not see our ODBC connection in the list of server names. The list is blank. We did create the System DSN correctly. Any ideas? Are you logged in as an administrator of that machine? Usually when you create a system DSN as a non-administrative user, for some strange reason Windows will let you continue with the procedure, but will not save the connection. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com The Dynamics GP Blogster a...

Leave a Copy of Messages on Server
Office XP SP3, Outlook 2007 SP1 I like to leave my messages on the server in case I'm away from my regular computers. I can still reference them with webmail. I use Outlook on 2 different computers, however. After I've checked my mail on one of them and then use Outlook on the other computer, I will get duplicates of all the emails that I received on the first computer. It looks like each Outlook program keeps it's own record of where it stopped downloading. Is there a way to tell Outlook to only download unread emails? Is there another solution? I suppose I could del...