Do I need stop Agents during primary Server power down?

Hi,
Does anyone can tell that our production primary site need perform server
power down, and I have the databases transactional replication with push
setup on primary site? The secondary site will run all the time. Before,
primary site perform the power down, do I need stop the Log Reader and
Distribution Agents? What if I am not stopping those agents?
Regards,
Chen
You will be fine. Transactional replication replicates transactionally. So
if you power off in the middle of something, when it starts up again, it
will pick up where it left off.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:D91896AE-5BF7-47FA-A0D7-D4BFC0CAF422@.microsoft.com...
> Hi,
> Does anyone can tell that our production primary site need perform server
> power down, and I have the databases transactional replication with push
> setup on primary site? The secondary site will run all the time. Before,
> primary site perform the power down, do I need stop the Log Reader and
> Distribution Agents? What if I am not stopping those agents?
> Regards,
> Chen
>
sql

Dling support?

Hi All.

What can we do to let the power that be know that there are many of us that want Dlinq to support SQL ev?

They say they are considering it, how can we help them deside?

Mike Greenway

You did the right thing by posting the request here - the MS SQL Everywhere team watches this forum and is very responsive to this sort of input. After all, that's how we extended the licensing of SQL Mobile to result in a new release called SQL Everywhere (that and very vocal MVPs).

The one thing about LINQ that I'm sensing is that it is a short-lived idea even on the desktop ADO.NET provider - it may be a stepping stone toward an easier way to achieve ORM, and an initiative is under way called the Entity Management Framework which may supecede the LINQ idea. Just my opinion, not an official statement.

http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnvs05/html/nxtgenda.asp

-Darren

|||

Cool, Great, WOW

What I REALLY want is LINQ and I thought DLINQ was the ONLY way to get it.

ADO.NET's Entity Framework looks like it is VERY handy. If it is truly going to be available in Aug. I'm going to delay writing that part of my code until then.

I never liked SQL strings.

Thank You, again.

Mike

|||

I hate to bring you down to Earth, but DLINQ and/or Entity Framework most certainly won't be available in Aug for devices.

|||

Hi Ilya

What do you think, a CTP in that time frame?

If I had a CTP I could get started.

|||

They did it and the CTP is ahead of schedule too.

http://blogs.msdn.com/adonet/archive/2006/08/15/701479.aspx

I'm going to take a look.

later

Mike Greenway

Dling support?

Hi All.

What can we do to let the power that be know that there are many of us that want Dlinq to support SQL ev?

They say they are considering it, how can we help them deside?

Mike Greenway

You did the right thing by posting the request here - the MS SQL Everywhere team watches this forum and is very responsive to this sort of input. After all, that's how we extended the licensing of SQL Mobile to result in a new release called SQL Everywhere (that and very vocal MVPs).

The one thing about LINQ that I'm sensing is that it is a short-lived idea even on the desktop ADO.NET provider - it may be a stepping stone toward an easier way to achieve ORM, and an initiative is under way called the Entity Management Framework which may supecede the LINQ idea. Just my opinion, not an official statement.

http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnvs05/html/nxtgenda.asp

-Darren

|||

Cool, Great, WOW

What I REALLY want is LINQ and I thought DLINQ was the ONLY way to get it.

ADO.NET's Entity Framework looks like it is VERY handy. If it is truly going to be available in Aug. I'm going to delay writing that part of my code until then.

I never liked SQL strings.

Thank You, again.

Mike

|||

I hate to bring you down to Earth, but DLINQ and/or Entity Framework most certainly won't be available in Aug for devices.

|||

Hi Ilya

What do you think, a CTP in that time frame?

If I had a CTP I could get started.

|||

They did it and the CTP is ahead of schedule too.

http://blogs.msdn.com/adonet/archive/2006/08/15/701479.aspx

I'm going to take a look.

later

Mike Greenway

Distribution Server - Replication

What happens when Distributor Server goes down in Transactional
Replication, no corruption (power , hardware failure)??
Thanks,
JohnCan you bring the distributor back up or the distribution database is lost? Before you bring the distributor back up, you need to shut down all subscriptions. If you can restart the distributor, you need to stop the logreader right after you have started the SQL Agent on the distributor. Open the subscription first to see if they can be synced. If the subscription doesn't errored out, open the logreader. Good luck!