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.

in the current scenario you may have max 1 day data loss, if the DB crashes before defferential.

if it is ok , you have defferential to restore back.

if you cant...

Maintenance plans are built in SSIS packages and T-SQL are sql code.

both of them has to use jobs to execute at certain intervals or time.

it is your option and nothing...