Re: How to import Data strcture from .mdf and .ldf, not Data.

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 08/05/04


Date: Thu, 05 Aug 2004 08:29:54 +0100

Terry,

Refer to this article, it's very useful.

Microsoft Knowledge Base Article - 224071
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/?id=224071

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Terry wrote:
> Hi, All
>     I have database files of SQL Server 2000: .mdf and .ldf. I want to
> import data structure of this database into the other Microsoft SQL SERVER.
> Would you tell me the way how to do it? Thanks!
> 
> 


Relevant Pages

  • 18454 Log message
    ... (Microsoft Knowledge Base Article - Q288426) ... to be fixed with the latest servece pack. ... We have the Microsoft SQL Server 2000 Standard Edition ...
    (microsoft.public.sqlserver.security)
  • RE: MSDE2000a Fails to install - actually uninstalls itself
    ... Thank you for your post regarding MSDE2000a install fails on Windows 2000. ... Check out knowledge base article "315083 PRB: SQL Server Desktop Engine ...
    (microsoft.public.sqlserver.msde)
  • RE: Uninstallation of SQL Server Express Edition CTP
    ... Please use Windows Installer CleanUp Utility described in following ... Knowledge Base article to uninstall the remaining SQL Server Express and ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server startup
    ... There is a knowledge base article on this: ... The article only mentions running perfmon at the console, ... also have to check scheduled perfmon trace logs as well. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • RE: Error CO_E_DLLNOTFOUND
    ... The following Knowledge Base article may help analyze memory dumps to look ... a storage card, thus, saving space in main storage. ... Change the Temp Database Location in SQL Server CE ...
    (microsoft.public.sqlserver.ce)