"Timeout Expired" when restore a database using EM

[gord2]

I have a SQL 2000 server. I use enterprise manager to restore database.
I'm able to restore databases from SQL backup files when the backup file is small. However when I try to restore large databases (I have 3 databases with files size above 1 Gb) I get this "Timeout Expired" msg. The msg window's title is "Microsoft SQL-DMO (ODBC SQLState HYT00)".

How can I restore large databases?

Thanks in advance.

Gordon.

 

[mrdenny]

Try doing the restore through Query Analyser. You can get the full syntax from BOL under RESTORE DATABASE. The basic syntax is:

restore database {datebase_name} from disk='d:\path\to\restore\file.bak'

Denny

--Anything is possible. All it takes is a little research. (Me)