Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Loading/Suspecting when I tried to restore database through backup file.

    I can run this example from SQL Book Online from sql query analyzer. I can build the TestDB database.

    BACKUP DATABASE Northwind
    TO DISK = 'c:\Northwind.bak'
    RESTORE FILELISTONLY
    FROM DISK = 'c:\Northwind.bak'
    RESTORE DATABASE TestDB
    FROM DISK = 'c:\Northwind.bak'
    WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
    MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
    GO

    But... When I build stored procedure and call it through VB6. I've got the gray database symbol along with message TestDB (Loading/Suspecting)
    Why I cannot run these commands through VB6

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My guess is that the load is still in progress, and that you just need to wait for it to complete. You might have other problems, but that seems likely to me at the moment.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •