Lynn Pettis (1/20/2010)

---

shripati (1/20/2010)

---

Hi...

You can try this steps:

Truncate the log file --- and shrink it to minimum size possible.

This is the code...

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC...

Hello,

Try this ...

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<TransactionLogName>, 1)

GO

Hope this helps ...

\\K

Donald Burr (1/19/2010)

---

Nice answer from SQL-Quest.

We script ALL of our replication and NEVER use the interface.

It allows us to break-down are rebuild all of our replication publications and subscriptions...

Vinay Thakur-585143 (1/19/2010)

---

Sorry for confution,

follow this

declare @JobID uniqueidentifier

select @JobID=job_id from distribution.dbo.MSdistribution_agents

where publisher_db=publisherDBName

-this will give jobid for the replication we have created, just use that jobid and rename the job.

exec...

I think that I was not clear of what I want to do .. Let me try explaining..

I want the distribution job...

Vinay Thakur-585143 (1/19/2010)

---

use [DB_name]

exec sp_addsubscription @publication = N'[Pub_server_name]', @subscriber = N'[Sub_server_name]', @destination_db = N'[DB_dest_name]', @subscription_type = N'Push', @sync_type = N'replication support only', @article = N'Program', @update_mode...

Vinay Thakur-585143 (1/19/2010)

---

More information on this.

exec sp_addsubscription ....,@distribution_job_name ='Distribution1'

Here @distribution_job_name is system use only but if we provide value to this, it will keep it for internal tables for...

Vinay Thakur-585143 (1/19/2010)

---

we never required to change the distribution job, and yes @distribution_job_name is for internal use only :(.

For now I could see the workaround like this.

declare @JobID varchar(1000)

select...

EdVassie (1/19/2010)

---

I do not think there is any way to get your jobs generated with meaningful names. The only option is to change the names after they have been...

Vinay Thakur-585143 (1/18/2010)

---

you can add article using

sp_addarticle

HTH

vinay

http://rdbmsexperts.com/Blogs/%5B/quote%5D

We have many requests coming in to add articles every week. As vinay mentioned ... use sp_addarticle to add article.

This is...

Vinay Thakur-585143 (1/18/2010)

---

As I understand your question, you want to setup the distribution job name and schedule, which can be setup in

sp_addsubscription

please see BOL for options.

I think option

@distribution_job_name...

Still working ... any ideas Experts ? :hehe:

ganci.mark (1/13/2010)

---

Thanks Harold. That's exactly what I was thinking. If Sql version, Virtual server name, ip address,instance name, install path, and drive letter are the same then I should...

Thanks Gail and Jon for your replies

I am still not sure that the extra 150 GB can be used without a reboot :w00t:

I cant remember, but there is a...

Thanks for your reply !

What does Mark as Active partition do ? (disk...