Sounds to me like your vendor is trying to blame something that sounds like an IO subsystem performance problem on the internal workings of SQL Server.

The time between checkpoints is...

Is it the SQL Service restarting or the whole machine being rebooted?

Is this part of a cluster or a standalone machine?

I tend to agree that it is best to backup locally first and then copy to a remote server. But if that option is not currently available to you, then...

What error message, if any, are you getting?

AFAIK - There is no SP for R2 yet.

In sql server (any version) we have the checkpoint process which writes the dirty pages to the disk periodically , right?

My question is what kind of dirty data does it...

The only problem with disabling remote connections to the SQL Server is if your app connects from a different server then that too will error.

SQL Server does have a very...

ALTER DATABASE DBNAMESET SINGLE_USER WITH ROLLBACK IMMEDIATE

The database will be in single user mode after this has run.

If you are rebuilding/reorganising and maintaining your indexes regularly then you may be wise to set the size of your log right up front to allow for it....

To add to John's reply, you definetely cannot restore a 205 database to a 2000 server.

Pardon my ignorance to what could be a really stupid question to all you DBA's out there , the maintenance plan wizard options allows you to choose backup database and...

Gregg Your best bet will be to run a trace that capture activity on the database, that way you can see which statements are being executed, when and by whom....

I pretty much agree with Henry_Lee except I prefer the backup and restore method. Mainly because I then have two copies of the data.

No - Not as far as I know.

Hi Steve

If you still need someone to write this article I will give it ago.

Geth