+1

Please don't try this ever.

Just try this.

select log_reuse_wait_desc,* from sys.databases where name='dbname'

-- see what it is waiting on

also run this dbcc sqlperf(logspace)

--...

A question: If setting "'allow_anonymous" and "immediate_sync" allows only the new article to be replicated instead of the entire snapshot. Then why would these settings "FALSE" not be the default?...

happycat59 (4/14/2013)

---

You could try using "sp_addsubscription" and specifying the name of the article that contains the new table. Follow that with running the snapshot agent for the publication and...

UncleBoris (4/14/2013)

---

I am doing some testing with Replication, I have not used much replication before.

I have set up a Subscription that uses Transactional Replication and works fine when I...

Yes you are right.

Now, I checked again. On explicitly adding my account to content manager role I could view the upload button.

But now, the files are Crystal .rpt files. How do we...

Just to add, the mirroring mode is high safety without automatic failover.

When I run this query

SELECT mirroring_witness_name, mirroring_witness_state FROM sys.database_mirroring

mirroring_witness_name mirroring_witness_state

...

robert.gerald.taylor (11/11/2012)

---

mohammed moinudheen (11/11/2012)

---

sanket kokane (11/8/2012)

---

do you have copy of mssqlresource database files before the installation of service pack .

if you are lucky and you have copy of these...

sanket kokane (11/8/2012)

---

do you have copy of mssqlresource database files before the installation of service pack .

if you are lucky and you have copy of these db files ,...

Now it's working. I didn't do anything. Could be it is a not a SQL related problem. May be something else changed and it didn't work for a while.

Yes, I am trying correct URL.

http://servername/reports

Quite weird.

I also checked the IIS server logs and didn't get any information either. Have anyone of you experienced this before?

Thank you for all the inputs.

Very good one Perry.

Rated it 5 star