October 28, 2003 at 11:43 am
I am attempting to restore a backup from another server and I am getting a "Timeout"
This server is SQL2K std, latest sp/fps.
I believe the other server was EE, at SP1, and had Analysis services on it. But I just want to restore the DB.
Any ideas ???
KlK, MCSE
KlK
October 28, 2003 at 12:14 pm
How do you do the restoration, using command in QA or restoring it with EM? What is the exactly error message? I don't think the edition of SQL server is the problem.
How large the database is? Can you restore a sample database such as 'pubs' succcessfully?
October 29, 2003 at 9:40 am
Well I was getting the error doing a restore with EM, I avoid command line stuff. (I use too much for DB2).
But I tried it with QA command and it worked. Thanks for rattling my cage Allen.
Still don't understand why it errored out with EM, I have restored other DBs many times with EM. But it is solved,
Thanks Again.
KlK, MCSE
KlK
October 29, 2003 at 9:59 am
Check the time-out setting in SQL Server EM --> Tools --> Options --> Advanced Tab.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply