Top stuff 😎

Now for SQL Server 2000, I would do ... :ermm::crying:

philcart (10/1/2009)

---

Firstly, you're using SQL Server Express which has a hard wired limit of 4GB for the maximum database size. Individually, not that big really, but you have alot of...

Both valid points. But bear in mind that reducing SQL Server memory even further will push more work onto the disks where your real problem is.

You can change the names to protect the innocent. 😉

Are you able to post the output from RESTORE HEADERONLY and RESTORE FILELISTONLY?

Fastest path to less timeouts would be to bury the problem in super hardware 😀

Short term, you aren't really going to get much bang for your buck.

Best option with the...

If you're restoring over an existing database and it has the same logical files, you don't need to use MOVE, the replace will replace the existing files.

Does the backup device...

hemul (9/30/2009)

---

Hi people, I need some advice.

We have a very large installation of sql server express, about 200 clients at different geographical locations.

All clients are accessible remotely through our vpn...

I grabbed the stats you posted on the other thread.

For the wait stats its pretty cut and dried.

PAGEIOLATCH_SH 1130875600 24069458365 300005 126621887

You've accumulated over 278 days of IO wait...

Or you could forget using maintenance plans altogether and simple T-SQL commands. You could roll your own, or use one of the many stored procedures in the script library.

Sounds like a single disk array on which you have OS, paging file, tempdb, data files, log files and backups. You may have partitioned the array into multiple logical...

I may have missed it in the earlier replies, but have you also checked the NTFS permissions as well as the share permissions.

Better idea is to perform a RESTORE HEADERONLY FROM DISK = '...'

With that you can find out all you'd ever want to know about the backup.

Check http://msdn.microsoft.com/en-us/library/ms178536.aspx

I believe \Device\Scsi\dpti2o1 refers to an array adaptor.

Check if the adaptor has the latest firmware/drivers/etc...

Promising start ... eagerly awaiting more ... this is one DBA that doesn't mind diving into .Net, as long as its C# 😉

Also, for the record, the most servers I've...