Showing posts with label shipping. Show all posts
Showing posts with label shipping. Show all posts

Monday, March 26, 2012

Maintenance plan "Backup transaction Logs" running out of control

I have a miantenance plan that backs up transaction logs to another Server for the use in Log shipping. this has been running fine for months now, but the other day it has been spitting transaction logs that are 2.5 G over and over. about 20 G so far.

I tried to delete this plan and create a new one and reset Log shipping but it is still spitting out these 2.5 G files. I am really not sure what to look at next.

thanks for any help in advance.Why use a maintenance plan for this?
It is really easy to implement tsql and scheduled tasks and then you will at least know what it is doing.sql

Wednesday, March 7, 2012

Mail Merge & SQL

I need to mail merger information in a SQL Server DB to word to make shipping labels for part vendors. I need the abilty to select the vendor by the vendor number and specify how many copies of each to print. I have the DB mail merged to Word but I can not figure out how to do the select parthttp://support.microsoft.com/default.aspx?scid=kb;EN-US;q285176 -KBA way to go.

HTH|||damn skunked again.|||Originally posted by Ruprect
damn skunked again.
The user opens the word doc, types in the vndNum/s they need, clicks a command button, which sends them back the queryed info from the server DB. MailmergeOne is not doing this for me. Any other ideas.