GilaMonster (10/13/2010)

---

On SQL 2008 the mssqlsystemresource is in the...

Oliiii (10/13/2010)

---

Check how large your differential backups would be.

Send them a full backup once and and then differential backup every day or so (probably more data sent overall but in...

Sounds like it would be worth your while investing in a tool that creates compressed backups. Should be able to get a backup file about 20% uncompressed size.

Nice Marmot (10/12/2010)

---

This has been a very valuable thread to read. Maybe the OP might be interested in this disk partioning article: http://msdn.microsoft.com/en-us/library/dd758814.aspx.

One point I did not see discussed...

You still only need to send over and restore the log backups.

The URL states that view server state AND select permission is required, so grant view server state and select only on the dmvs you want them to be able to...

what you have described will work. see

http://msdn.microsoft.com/en-us/library/ms188754(v=SQL.100).aspx

once you have restored the first full backup, you only need to restore the log backups, its called logshipping 🙂

Donalith (10/11/2010)

---

Thank you so much for your help!

I'm going to go with the detach, copy, and reattach. That'll leave a viable database on the first server while I'm working on...

I would avoid that method like the plague.

WayneS (10/10/2010)

---

Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

Any suggestions on good, inexpensive, close places to stay?...

everyone has to start somewhere. yep BOL is...

backup and restore is probably the safer way to do this (in terns of backout). also almost always means a smaller file to copy but you have the added time...

shanila_minnu (10/11/2010)

---

what...

running a log backup should shift those. Find out who is controlling sharepoint administration.

Personally I would turn their log backups off and rely on native SQL ones.