what are you trying to do, are you trying to save the output of configuration sp's in the table and do some manipulations?

DBA level depends

is he/she going to take care of DB only.

will he/she take of storage/hardware for servers

kindly specify the details level for the DBA?

use "Microsoft sql server best practice analysizer" it will suggest you the best practices.

500 rows are smaller tables you can think of move old data to different table/DB once it is over 4 or 5 millions records in a table.

are you facing any...

[quote-0but I'm not sure where to store this database. I'm also unsure of how to get my information from the servers that are outside of the trusted network to my...

what are you going to do on this?

as robin said your explainations are confusing, can you reply to his first reply.

do you want to keep old backup for 7 days?

follow this as well and answer the above if this is not your query

http://www.sqlservercentral.com/Forums/Topic1348066-146-1.aspx

Indianrock (8/22/2012)

---

The application does use an ORM. What is being proposed by our Senior DBA is partitioning along with with a view using union all to cover the primary...

Not harsh like this, but space management involves backup space on a...

can be done for a date range or so by having multiple partitions

As lynn specified if it is done correctly everything will be good.

oh god, we are moving to windows authentication now, what to do?

are you talking about only few tables? if then try import/export.

great, i missed it, try to included clayman ideas as well.