I think I found a problem with security to the folder on the file share. From my understanding the sql db engine account has to have full control of the...

Thanks for responding. I haven't created the 'Test' database, I was hoping that I could restore from the backup file to create and populate the 'Test' database but I get...

I have my database, jobs and stored procedures setup to collect and store baseline statistics on server A. I am now trying to figure out how to gather data from...

Thanks for the information! I have responsibility of sql server 6.5, 7.0, 2000, 2005, 2008R2, and 2012. I have been able to get the 7.0 backups onto the fileshare. I...

What do you do when you have to restore a full backup and then a differential and a log? I am able to restore the full backup but I end...

Thanks Grant

I added indexes and I was able to bring cpu down. I have more tuning to do. I am ready through your book 'SQL Server Execution Plans'. Your book...

Ok now I have permissions setup on the fileshare folder. When I try and do a restore using the ssms gui and choose source from Device my fileshare is not...

I too use Adam Mechanics sp_whoisactive. I was able to cut my cpu usage significantly. Good tool to learn how to use

Kathy

I did request the security on this fileshare but now I'm looking at it, I don't see the security I will need. I will request this again and see what...

Restore of database 'dbname' failed. System.Data.SqlError: Cannot open backup device 'default drive name' (The system cannot find the file specified.), (Microsoft.SqlServer.SmoExtended).

This is the error I am receiving.

Thanks

Kathy

Thanks for the input. I'll do more research and traces and analysis to try and determine our problems

Kathy

I was never able to find out if there is a bug in SP2 or not. I have installed SP2 SQL Server successfully on other servers, because of these...

Thanks Kevin. Mirroring isn't part of our disaster recovery as of yet. We are a relatively small evolving sql server shop and there is a lot for me to learn.

The corrective action was to restore the master database. I know longer have the error log. What we decided to do after a lot of trial and error was to...

The corrective action stated to restore or rebuild the master database. We tried to restore and that didn't work. We're working on a rebuild--tried to rebuild the master using the...