1. SQL Server 2K with Service Pack 3.x.
Steps to generate error in Enterprise Manager.
Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.
All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.
Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.
2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.
What would be the cause and remedy.
Thank you for your thoughts.
Smith
Here is the update on this issue...
Restore database window appears after long wait.... more than an hour.........
It never use to be so earlier.
What got changed recently?
SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.
When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?
Any thoughts?
Thank you,
|||
|||
|||
Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.
-Sue
No comments:
Post a Comment