Member Avatar for Kylan

Hi,

I need to make a copy of a ms sql 2000 database and send it to another person. They are asking me to send the database schema. I would like help on this since is something I never done before.

Thanks

Javier

  • 2 Contributors
  • 1 Reply
  • 62 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

right click on the database->all tasks->take offline
go to database location copy and paste it anywhere
after that
right click on the database->all tasks->bring online

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.