I tried that too.

when i go to that link and open up systbl.chm, nothing is there, "action cancelled"?

Brian

I did start to look through the other files though.

Ok, so am i missing something or what?  If the master db contains all my logins and system setting, how do I restore it?  Is there way way to create...

So, if the Master is the Heart of the database, then, my database is not completly restored, untill I restore it?  Does not body restore the master, or do they...

Can you explain to me why it is not recommended?  I hope to understand this, so if you have a few more minutes

how long should that take?

Can you tell me how to check if the tempdb is used alot?  I didn't program the application using this db, so I don't know if it uses that table...

Never Mind.. I got it.. forgot the file name on the move...

Hi,

when I run this scrip I get the error that is included..

RESTORE DATABASE [RSMS] FROM  DISK = 'C:\Temp\RS_Server Backups\rsms.bak'

WITH  FILE = 1,  NOUNLOAD ,  STATS = 10,  RECOVERY , ...

sqlbill,

No I am trying to restore on a test system.  You referred to "BOL", what is "BOL"?

ramses2nd,

I will try that.  And I should restore each file like that, with the...

Thanks, both of those I will find useful.  Great Job.

I am curious to Ian's response.  I tried yours too,  and don't under  the results,

here is what I came up with

use...

I am a newbi to sql, but wouldn't a backup of the transaction log "with no_truncate" help in your situation?  Remember I am a newbi, so please look up that...