This script works fine but I'm still wondering if there are SQL 2005 system views for restore info.

use msdb

select

DBRestored = destination_database_name,

RestoreDate = restore_date,

SourceDB = b.database_name,

SourceFile = physical_name,

BackupDate = backup_start_date

from RestoreHistory...

Hi SQL Noob and Rubes,

Could you provide examples of scripts that you use successfully? Thanks.

Ryan

I'm still puzzled as to why the indexes are not being reorganized/rebuilt. After performing a rebuild of all indexes on a table (either with TSQL or in SSMS) I...

Thanks for the link to Eric's article, will definitely check it out...

As mentioned, I am looking into Dynamic Management views and there is a script on http://msdn2.microsoft.com/en-us/library/ms188917.aspx that...

Thanks for the advice. I found this article on using dynamic management views to maintain indexes:

http://msdn2.microsoft.com/en-us/library/ms188917.aspx

BTW, if anyone knows of any guidelines on how to configure built in scheduled job tasks for (Rebuild Index Task, Update Statistics Task, Check Database Integrity Task, etc) please let...

Thanks for your response. I'm getting some weird error messages. When I try to drop the table I get "Cannot drop the table '#fileexist', because it does not...

Thanks for your response.  As far as I can see, the SQL Server Import and Export Wizard only allows you to copy tables.  Other objects such as views and SPs...

Guys, thanks for the suggestions. I'm going to try using a scheduled job with a script that creates the backup files with a filename that is easier to work...

Thanks for the suggestion. It sounds like I won't be able to modify the filename of the backup if I'm using a maintenance plan so I'll need to schedule...

Thanks for your reply. It's kind of a kludgy setup but we're required to copy these backup files to a DRF and restore them there daily. I'm unable...

Actually I can't use the backups recorded in MSDB because these backup files are copied from another server. I'm attempting to automate restores of .bak files from another server,...

That's correct.  There are multiple members (contractors) who have access to the DBs.  Using DISTINCT allowed me to include them all in the list, so some DBs show up more...

I solved the problem by selecting DISTINCT DBs and eliminating the AND statement in the WHERE clause (DBAccounts.Accesstype = 'dbo'). Thanks.

SELECTDistinct DBs.DBName,

ServersDev.ServerName AS DevServerName,

ServersProd.ServerName AS ProdServerName,

Agencies.AgName AS Contractor

FROMDBs INNER...

Thanks for your reply. I modified the script to this and now I get 126 rows returned, but many of the DBs are still listed twice, where as they...