Not sure what you mean by "differential restore".  Perhaps you need to set up replication again.  I've never had to do this before.  Have you checked the Microsoft website to...

Impossible to give a meaningful answer, but here's a guess:

1. 2 days

2. half a day

3. 1 - 2 days

4. 2 hours

5. 1 week (plus planning)

You can back your large databases up. ...

Have you tested your assumption that the silly proc1 would time out if run in a loop?

Marco

To help you out, we'll need to see the code in the stored procedure, and probably also table DDL and sample data.  Then we may even be able to help...

I would say you can't do it in that timeframe.  But then you knew that anyway.  Management is going to have to decide whether the postpone the live date or...

No need to ask the same question more than once.  Answered here.

Irene

You can set the max server memory and the min server memory on SQL Server, and SQL Server will allocate itself memory dynamically based on those constraints.  The min server...

When I've had servers restarting for no apparent reason in the past, it has often been traced to the network card.  Are your NICs teamed, by any chance?

John

I noticed after I posted my reply that you're on SQL 2005, so I may not be the best person to help.  However, if replication on 2005 is anything like...

Meena

Look at the differences between the two servers - memory, disk, processor.  Does the log file continually grow during the import on the second server?  Do you have the same...

Look at the properties of the MSSQLSERVER service in the Services applet.  You can also find the same information in Enterprise Manager by right-clicking on the server name, choosing Properties...

Dave

I think the biggest risk is in terms of performance.  Both SQL Server and IIS like to grab as much memory as they can.  If you are short on resources...

If you're asking will the query optimiser use the index on PK_TAB_B, the answer is no, not if the PK is defined with the columns in the order you specify. ...

I think you will be able to achieve what you want with replication.  You can use the replication stored procedures to transform the data using code similar to what you...

Luis

It shouldn't be a problem.  If you try to create a stored procedure that calls another that doesn't exist, you'll get a warning message but the stored procedure will be...