The thing to compare is how long the shrink takes v the copy. If the copy is quicker, and it could be since that isn't a lot of downtime, why...

Yeah, that's it. I think I've been working with MS Server products too long.

It's an interesting question. Good to see there's a Connect item on it, and people should have learned things.

Not sure how I feel about the question. Definitely if the server...

webrunner (4/29/2010)

---

Minor spelling quibble. I believe the spelling is "shear forces," not "sheer forces."

Thanks for the editorial, though - it really got me thinking again about the construction metaphor for...

Baking. Made chocolate croissants this morning.

It's hot linked, but it's Back Office Administrator from Hell: http://www.theregister.co.uk/odds/bofh/

Your ed is coming soon. Haven't had time to go over the podcast, but I'll get it sorted and out next week.

It does seem to be tough pulling information out of people today. The "ideal SQL Server" thread has me slightly frustrated.

Gregory,

How about if we ask is there an existing system? Taking guesses on new servers without any history is hard. Any ideas on how much data/activity this system will see...

You want lots of memory, enough CPU for your system load, and a few separate physical disks. These can be DASD or SAN, but you want to have data separate...

MANU-J. (5/3/2010)

---

Renuka,

As per http://msdn.microsoft.com/en-us/library/ms179344(SQL.90).aspx

The loss of a partner has the following effect:

3. If the only mirror server becomes unavailable, the principal and witness continue.

Hope this answer your...

Why isn't Asset2 linked to MasterAsset1 in the result? What you've posted doesn't make sense.

Third vote for Express. If you go with SQL 2008 R2, you have an increased 10GB size limit.

You also have workgroup to go to if you are watching costs.

Editions...

For backups, typically you would write a script or use a maintenance plan for the backup and schedule that as a job. Here are a few resources for that:

http://www.sqlservercentral.com/articles/1535/

http://www.sqlservercentral.com/articles/1353/

Note that...

Lots of scripts here for you: http://www.sqlservercentral.com/Search/?q=backup+log&t=s