|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > I cant create a New Database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
I cant create a New Database
|
|
|
| Hello everybody !!
Please I need HELP !!!!!
I am working with SQL Server 6.5.
I need to create a new database to restore it from a tape
backup.
Everytime I create the new database, it be on LOADING
status for a while. Last time was like 5 days in LOADING
status.
Any idea about it?
Thank you very much for help and time  )
Luis
| |
| Bob Pfeiff [MS] 2002-08-15, 9:23 am |
| Have you tried the restore yet? If you create a database for load, that
will be it's status until you load it at get it online. I don't remember
all the details of the process, but there should be info in books online
about this.
--
Bob
Microsoft Consulting Services
------
This posting is provided AS IS with no warranties, and confers no rights.
| |
| Roy Harvey 2002-08-15, 9:23 am |
| Luis,
>I am working with SQL Server 6.5.
>
>I need to create a new database to restore it from a tape
>backup.
>
>Everytime I create the new database, it be on LOADING
>status for a while. Last time was like 5 days in LOADING
>status.
Are you creating the DB with the FOR LOAD option? Have you started
the database LOAD from the backup, or are you waiting for the status
to change first? If the CREATE DATABASE has finished, try just
running the LOAD DATABASE and see what happens.
Roy
|
|
|
|
|