The differential backup records all changes to the database since the last full backup.  So if you wanted to restore on Friday, you'd need Sunday's full backup and Friday's differential...

I notice you're appending your backup to the backup device (WITH NOINIT).  Have you checked that the 9.5GB doesn't consist of more than one backup?

John

Paul

That all depends on what the full names look like.  Are there any double-barrelled surnames or first names that consist of two separate words?  If so, do they have a...

Chris

You could shrink your database, back it up, and then expand it back to 160GB again.  I don't recommend that, though, because it may cause fragmentation on your disk.

Probably best...

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...