| Author |
Loading Status after Restoring
|
|
| Sohail 2005-10-17, 1:23 pm |
| Hi:
Any help will be greatly appreciated. After I restore the database from
full backup, the database shows loading status. I am not restoring any
transaction logs or differential backup. I don't know why this is happening.
I am using the following systax:
Restore Database XYZ
From Disk = '...'
with Move .....
Please let me know.
Thanks
| |
| Jerry Spivey 2005-10-17, 1:23 pm |
| Did you specify NORECOVERY? Tried refresh in EM - Databases?
HTH
Jerry
"Sohail" <Sohail@discussions.microsoft.com> wrote in message
news:367E5ECB-D81A-49DD-8722- D9C759FDFA7A@microso
ft.com...
> Hi:
>
> Any help will be greatly appreciated. After I restore the database from
> full backup, the database shows loading status. I am not restoring any
> transaction logs or differential backup. I don't know why this is
> happening.
> I am using the following systax:
>
> Restore Database XYZ
> From Disk = '...'
> with Move .....
>
> Please let me know.
>
> Thanks
| |
| Hari Prasad 2005-10-17, 1:23 pm |
| Hi,
If you still have loading status after refresh then; Did your restore
completed successfully. If yes then execute the below command and see
if your database recover:-
RESTORE database <DBNAME> with recovery
Thanks
hari
SQL Server MVP
"Sohail" <Sohail@discussions.microsoft.com> wrote in message
news:367E5ECB-D81A-49DD-8722- D9C759FDFA7A@microso
ft.com...
> Hi:
>
> Any help will be greatly appreciated. After I restore the database from
> full backup, the database shows loading status. I am not restoring any
> transaction logs or differential backup. I don't know why this is
> happening.
> I am using the following systax:
>
> Restore Database XYZ
> From Disk = '...'
> with Move .....
>
> Please let me know.
>
> Thanks
| |
| Sohail 2005-10-17, 1:23 pm |
| Thanks for replying. I did not specify NORECOVERY because I was not applying
transaction logs or differential backup. Ok. I will have my client try
"Restore database <DBNAME> with recovery"
Why would database will go into loading status if NORECOVERY was specified?
Please let me know.
Thanks
"Hari Prasad" wrote:
> Hi,
>
> If you still have loading status after refresh then; Did your restore
> completed successfully. If yes then execute the below command and see
> if your database recover:-
>
> RESTORE database <DBNAME> with recovery
>
> Thanks
> hari
> SQL Server MVP
>
> "Sohail" <Sohail@discussions.microsoft.com> wrote in message
> news:367E5ECB-D81A-49DD-8722- D9C759FDFA7A@microso
ft.com...
>
>
>
|
|
|
|