John and Damon,

Thank you very much for your help.

Thanks for your reply, Jeff.

Unless I misunderstood your reply, it is the query in SQL Server running against the AS400 linked server that is slow.

Can you suggest a different driver...

Thanks, Antares.

No, I haven't tried Openquery.

I'm actually selecting against a view.  I'm using Visual Studios to create a report model for Report Builder.

Thanks. Bob.

We do have a backup process to tape.

I posted the question because the other developer I work with believed that an uninstall/reinstall of SQL Server would delete the database files...

Thanks, Ratheesh!

Thanks, daniel.

Will look at assigning the Report Builder role tomorrow when I get to the office.

Thanks, Markus.

Thanks for your advice, Steve.  It's much appreciated!

Thanks for your suggestions, Mike.  We are running the Standard edition, so we can't use option 1. 

Thanks for your reply, David.

I don't yet know the answer to your question regarding history snapshots.

Can you suggest an alternative method in RS for page-level security?

Thanks, Mike!  Your solution should work for us.

Thanks, James.

I will keep your reply for future reference.

What I did before reading your solution was to export my database.  I right-clicked the database, then selected 'Tasks', then 'Export Data...'.

Seemed...

Need more help!

Backed up the database on the dev instance without a problem.

Loged in to the prod instance and attempted a restore by doing this:

1. right click database node

2. select...

Thanks, Sugesh!

Thanks Daryl.