New transaction will enter into 6th file.

Raghavender (4/14/2011)

---

If...

Change the column data type using ALTER TABLE command.

Don't use GUI. GUI would drop...

Run the following query and confirm that the mirroring end point is created successfully?

select * from sys.database_mirroring_endpoints;

Some of the information, you can get from the following:

select name, is_distributor, is_publisher, is_subscriber from sys.servers

use distribution

go

select * from MSpublications

select * from MSsubscriptions

select * from MSarticles

-- Shared folder

sp_helpdistributor

Check the permissions. This happens when SQL Server service account doesn't have read permission to your folder.

Do you mean "Covering" index?

Thanks Koen Verbeeck and opc.three

I appreciate your help.

Regards,

Suresh

Hi Suri,

Even though, your t-sql contains objects which are not replicated, the records will be deleted from the subscriber.

For example, if your t-sql command is:

delete a

from dbo.tbArticle a

inner join dbo.tbTable...

ashok_a2004 (3/2/2011)

---

Mirroing is highavailability solution and this is the primary role of this technology. There are two cases :

1. If you configured your mirroing with witness server in that case...

ashok_a2004 (3/1/2011)

---

Note : In SQL 2005 , this feature is bydefault. If you are working SQL 2005 , then no need to do anything . By...

Barkingdog (2/28/2011)

---

We have several processes that run Monday night (12:15am) that cause tempdb to increase by anywhere from 50 to 250 gb. How can we track down the culprit(s)?

TIA,

Barkingdog

P.S. Profiler...

gsuvarnarekha (3/1/2011)

---

Hi Bhuvenesh,

when ever your tempdb full then automatically sql server restarts so check that one and one more thing is are you checking any query which is running long...

Take tail log backup. Then restore the old backup and the tail...

luckysql.kinda (2/18/2011)

---

Hey Roy,

I also thought the same thing but when I run the snapshot this started creating the files even for the tables which already existed. I just executed the...

Duplicate post

http://www.sqlservercentral.com/Forums/Topic1033318-146-1.aspx