A restore normally restores permissions also.

Are you restoring to a single-user mode (restricted) or multiuser?

I had problems with permissions not being restored in restricted mode (only dbo permissions remained).

Can you find the specific error?

It only starts deleting files after all the backups were succesfull.

is a hard limit in msde 2000

http://www.petefreitag.com/item/194.cfm

sql server 2005 express doesn't has that limitation

http://databases.aspfaq.com/database/what-are-the-limitations-of-msde.html

Can you connect from server A using the ip address only (not by alias)?

It only starts deleting files after all backups are done succesfully. Do you have ample free space?

Is there a reindexing/rebuild/shrink operation going on the database?

You can find the current connections using the stored procedure sp_who2.

You can also start a trace with the profiler to monitor the...

The ping is a good start.

1) Is there a firewall running?

2) Can you connect to your MSDE using query analyzer on another machine (not using the linked server name). Sql...

That's odd. Normally the lesser the logical reads the merrier.

*Did you use DBCC FREEPROCCACHE to clear the execution plans?

*A stored procedure can be slower than a regular query because of...

Does a regular remote connect works (not as linked server)?

Have a look at

http://support.microsoft.com/kb/319892

Hello, I'm deprived of my sql installation for the moment, so this is from memory.

Memory: Pages/sec

9/15/2007 97.885

10/8/2007 24.389

10/15/2007 520.3

Is quite high. If it only spikes briefly at certain moments, it...

1. How can I tell how much memory SQL Server is allocating and using?

There are specific performance counters like sql server memory : ...

another free commandline utility is 7-Zip

http://www.7-zip.org/

At busy-server times I use Query Analyzer instead of EM which tends to lock up at such moments.

sp_who2: show current connections

DBCC INPUTBUFFER (spid): show sql-query

It has also a schema-browser (tools->Object...

I see other things running on the server, such as mssearch.exe (Mem usage 52,352 K), so it would be good to get advice about what services can be safely turned...