+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 🙂