Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old March 19th, 2003, 09:55 AM
strenge strenge is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2003
Posts: 1 strenge User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
copying sql 2000 db from isp server

Greetings,

This is a novice with sql server 2000 here. We developed several sites driven by sql 2000 for a client; this client would like to eventually move to a new ISP and wants a backup of the existing databases.

My first basic "approach" question would be: if you needed to "hand over" a sql db, what would you be handing over?

My first answer to this question is to generate the ddl scripts to recreate the objects, but this doesn't take care of the data. So, after copying the ISP db(s) down to my development server using Enterprise Manager, I backed up to a file.

Is such a backup file useful on a different server? In other words, can they just point to this file and blammo, there's the db? I played with the restore in EM a bit, and it seemed like you could only restore a db that had been previously backed up on that server (it gave you fixed choices of databases to choose from). Would our client need to create a blank db of the same name first?

So, what I'm handing over as of right now is 1) the script to create the schema and 2) a backup of each database. Obviously if #2 works you don't need #1...

Most of the stuff I've found online and in my books does not really cover a situation like this, but I'll keep researching. In the meantime, any info is highly appreciated.

Rick

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > copying sql 2000 db from isp server


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway