Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: cannot see database

    i have installed MS SQL Server 2000, and in the manager i see all the defaults dbs like : master, model, msdb, northwind, pubs and tempdb

    i copyed a data base of my own (a .mdf and a .ldf) in Data folder and i cannot see it

    what is the problem??? how can i see it?/?

  2. #2
    Join Date
    Dec 2004
    Location
    Europe
    Posts
    20
    You must attach it first (make it known to the SQLServer).

    Use EM, klick the server node, right-klick the "Databases" (Folder-like) node, point to "All tasks", point+click "attach database" + put the other stuff in. ...

    Or RTFM the section about "sp_attach_db" if you would like to do it via SQL ....

  3. #3
    Join Date
    May 2004
    Posts
    3
    ill try that when i get home
    thx mate

  4. #4
    Join Date
    Dec 2004
    Posts
    46
    You need to attach the database and when the file open window pop-up, choose the file you have copied.

Posting Permissions

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