Gamingforce Interactive Forums
85242 35212

Go Back   Exploding Garrmondo Weiner Interactive Swiss Army Penis > Garrmondo Network > Help Desk
Register FAQ GFWiki Community Donate Arcade ChocoJournal Calendar

Notices

Welcome to the Exploding Garrmondo Weiner Interactive Swiss Army Penis.
GFF is a community of gaming and music enthusiasts. We have a team of dedicated moderators, constant member-organized activities, and plenty of custom features, including our unique journal system. If this is your first visit, be sure to check out the FAQ or our GFWiki. You will have to register before you can post. Membership is completely free (and gets rid of the pesky advertisement unit underneath this message).


Moving an SQL Database
Reply
 
Thread Tools
Black Mage
Nothing beats a Sunny Day!


Member 264

Level 10.71

Mar 2006


Reply With Quote
Old Mar 15, 2007, 11:01 AM #1 of 3
Moving an SQL Database

I've recently begun working on a web directory application, which uses a SQL database backend. What I need to do is move the database from one computer (Which is acting as a Server using MS Server 2003), to a dedicated server in another room (Also using MS Server 2003).

The database is maintained using MS SQL Server 2000, and the dedicated, destination server will also be using MSSQLS2000.

The application is developed using ASP.NET with a C# backend. I'm not too concerned with the relocation of the source code, as I can easily remote in and get the files, but since I have little experience working with databases, I'm rather concerned with relocating it, and having it remain functional.

At this point, I guess my question for you guys is if you have any suggestion for an easy and safe way for relocating the database.

With that said, I haven't come into this without doing a little research of my own. My current theory (As I haven't had the chance to test it out yet) is that perhaps I can make a Backup of the current database, which is rather simple, and on the new destition server, set up a new server using that database. What I do not know about SQL Server 2000 is if it has the ability to create a new database from a backup of an old one.

If this doesn't work out, perhaps someone here knows if there is a specific import/export function in SQL 2000 which is made for just this situation.

Thanks a lot for your time guys, and I appreciate any responses!

How ya doing, buddy?
Reply


Exploding Garrmondo Weiner Interactive Swiss Army Penis > Garrmondo Network > Help Desk > Moving an SQL Database

Forum Jump


All times are GMT -5. The time now is 08:20 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2026, vBulletin Solutions, Inc.