[THIN] Re: moving a sql database
- From: Jim Kenzig <jimkenz@xxxxxxxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Wed, 18 Jun 2003 10:54:29 -0400
Back up the database using the SQL MMC to another directory. Copy the backup
over to the other server. Create a new database on the new server. Stop the
database. Restore it. If you right click on the database and choose all
actions Backup and restore are there. It is the same as if you were to
restore the database if it got corrupted. I think there is some info in the
advanced concepts guide also.
JK
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On
Behalf Of Michael Boggan
Sent: Wednesday, June 18, 2003 10:57 AM
To: THIN (THIN@xxxxxxxxxxxxx)
Subject: [THIN] moving a sql database
I have a datastore on a ms sql 2000 server. I am wanting to build a new
server to replace this one. How can I move the sql database from one server
to the other and keep the XP boxes connected to it. any suggestions?
Thanks,
_________________________________
Michael Boggan
Network Engineer/Citrix Admin
Virtual Desktop Inc.
Dallas, Texas
Ph: (972) 960-6400
Fax: (972) 960-6445
email: mboggan@xxxxxxxxxxx
http://www.virtualdesktopinc.com <http://www.virtualdesktopinc.com>
_________________________________
********************************************************
This weeks sponsor - RTOSoft TScale
Complaints about applications response time - DO SOMETHING ABOUT IT!
TScale 2.0 improves applications response time and increases terminal
server capacity. Really get MORE from your existing servers! Free eval:
http://www.rtosoft.com/enter.asp?id=130
**********************************************************
Useful Thin Client Computing Links are available at:
http://thethin.net/links.cfm
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
Other related posts:
