Re: Sql 7 to Sql2000

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Ssovie (anonymous_at_discussions.microsoft.com)
Date: 03/23/04

  • Next message: Rand Boyd [MSFT]: "RE: ASP/ODBC/Win2k - TCP Connections" 
    Date: Tue, 23 Mar 2004 10:16:06 -0800

    When I try to restore a backup file from Sql 7 to my Sql 2000 server I get this message. Logical file 'SqlScrpDb' is not part of database SqlScrpDb. Use RESTORE Filelist only to list the logical file manes. Restore database is terminating abnormally

  • Next message: Rand Boyd [MSFT]: "RE: ASP/ODBC/Win2k - TCP Connections"

    Relevant Pages

    • Re: Where are Views, stored procedures, stored?
      ... SQL VIEW and TABLE are objects of type *FILE; a VIEW is implemented as a LF [Logical File] extended attribute, ... The SQL INDEX in DB2 for i5/OS is also of type *FILE, ... If the external/referenced object exists before the CREATE statement, and the reference object is capable of becoming self-described, then future save and restore activity will enable the object to self-register upon restore. ... The aforementioned External Object Types are stored in *LIB objects, in the /QSYS.LIB file system. ...
      (comp.sys.ibm.as400.misc)
    • Re: SQLDUMPER library error message (PLEASE HELP)
      ... I ran services.msc and disabelled SQL Server VSS ... >>> Accounting 2007, a new program that I do not even know when or why I ... >> an MS Office 2007 trial - or do a System Restore. ... you'll see an entry made just ...
      (microsoft.public.windowsxp.general)
    • Re: 2nd Post: MSDN Subscriber - Sql Server 2005 Restore from tape fails ...
      ... After following Jeff's advice and executing a RESTORE FILELISTONLY I realized that the logical file names on the tapes did not have the .mdf / .ldf suffixes. ... I obviously don't understand the mechanics of restoring a database from tape as opposed to restoring from a set of .bak files on the hard drive. ...
      (microsoft.public.sqlserver.tools)
    • Re: 2nd Post: MSDN Subscriber - Sql Server 2005 Restore from tape fails ...
      ... executing a RESTORE FILELISTONLY I realized that the logical file names on ... the RESTORE worked great! ... MOVE N'sec_data_001' TO N'C:\Sql Server ... I obviously don't understand the mechanics of restoring a database from ...
      (microsoft.public.sqlserver.tools)
    • Re: Migration ?
      ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
      (microsoft.public.sqlserver.clustering)