UDBA, I will suggest to rebuild index as well after migration... It will be bad to hear that new server isnt performing better (in case)...

Grant people take you seriously... Be considerate... 😀

Use a monitoring software like MOM/SCOM/SQLSentry....

Use robocopy for transferring the backup files... Cant really comments on time taken to transfer... depends on your network speed

If you can use a compressed backup , even better...

Try breaking...

Create a trace and filter all keywords (insert/update/dete etc) and log to a table....

Why dont you create restore scripts immediately after backup.... and save for later use... ?

A table can not warn anyone on its own. You can certainly create a SQL job to check for table data and email students regarding preparation.

BTW whats stopping you to configure replication ??

farahnasir969,

Your requirement is unclear. Please provide more details. See this link.

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

This has been one of my favorite question. There are no right or wrong answers i expect. I just look for these points

- problem solving approach

- Ownership, candidates role in...

Row count is not returned in job history unless explicitly specified

print @@rowcount

Dont blame OP... I too thought her to be him (as is evident by her display pic) in my beginner days. I got corrected when when I visted her blog...

I learnt it the hard way... while i cleaned up few databases (after migration), users complaint of not being able to connect... though error message was quite obvious and hence...

Some people are plain lucky.... This was a pre production box... I solved this by Reinstalling SQL server 😀

Thanks for the info OTF... i will try this with OSQL...