 | Write 10,000 lines of code in 10 minutes!
Iron Speed Designer – Free Evaluation |
 WebProWorld Dev Forum |
Issue with 3 Windows 2000 Pro computers
I'm trying desperately to bandaid a network together for a client out of three Windows 2000 Professional machines in a peer-to-peer networking configuration, all plugged into a Netgear switch (the FS516...a bunch of their machines all died at once today).
WinXP disk needed to install/repair missing! HELP!
My brother-in-law quickly hit the power button on his laptop while still online(dial-up) to deal with a hospital emergency. now, when trying to reboot,the 'windows was not shut down properly' screen appears; none of the options-safe mode, last config,etc- work.
restricting internet access in WinXP?
I have a client who just asked me for a simple way to stop some of the computers on his network from accessing the internet with IE? He's running WinXp and my lo-tech solution of unpolugging the network cable is no good because they use VOIP. IE is the only browser installed.
|
|
 |
Recent Articles |
Indexes: An Overview and Maintenance for Performance
Many people know the importance of creating indexes on SQL Server database tables. Indexes greatly improve the performance of a database.
Change Password for SQL Server User
Most security experts' recommendations include changing passwords frequently to enhance security. It is easy to change the password on a SQL Server Username via Query Analyzer.
How to Attain SQL Server High Availability
You may find it hard to believe, but it is possible to maintain SQL Server high availability and not spend a fortune. In fact, you can spend a fortune and still not get SQL Server high availability. Sound like a paradox?
Creating Dynamic Website Content with PHP - MySQL
Fresh website content for your visitors can be of real benefit when attempting to generate repeat traffic. Most webmasters, however, just don't have enough spare time to frequently update or rebuild their pages manually.
MySQL for Beginners – How to create a MySQL Database
Whether you are an experienced web programmer or a complete novice attempting to provide data interactivity with your web site, MyQSL is an easy to use and free database solution that can allow you to store and configure data to be displayed on your web site.
|
|
| 07.19.05
Moving A SQL Server Database
 By Desirée Harris
A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server. The database will be offline during the move but it is better to have it offline than to miss transactions when backing up and then restoring the database on the new server.
In order to get the database moved with minimal downtime, be sure to complete as many tasks ahead of time as possible to move quickly during this process. Many times, a database move requires that the application that uses it to be offline and this time should be minimized as much as possible. These tasks include:
1. Identifying and opening all files that include connection string information to the database.
2. Open all necessary windows/applications to perform necessary tasks:
1. Locate and make note of the path and the name of the database .mdf / .ldf files on both the current and new SQL server for the database.
2. Identify all usernames and passwords for the database.
3. Open Query Analyzer on the new SQL server to run SQL commands.
4. Open Enterprise Manager on both the current and new SQL server to complete necessary tasks.
| Track issues, software defects, enhancements and change request - FREE Trial |
|
3. Read through instructions at least once to help the process go smoothly.
In summary, we'll backup the database, detach it, and then reattach it on the new sever. This process can be completed with Query Analyzer, but these instructions will be done via Enterprise Manager. Let's get started!
Backup Database
This is done as a precautionary step. This will allow us to have a good backup of the database up to the time of the move. (I actually do this before I make any changes to a database; you can never have too many backups!)
1. Open Enterprise Manager, and navigate to databases.
2. Right-click the database being backed up, select 'All Tasks' and then click 'Backup Database…'.
3. Verify and make note of database name and the backup destination path. I usually change the destination path to 'd: empdbname.bak'. It isn't necessary to change it, but ensure you can find it if you need it.
4. Under the 'Overwrite' section, select 'Overwrite existing media'.
5. On the 'Options' tab, put a check next to 'Verify backup upon completion'.
6. Click 'OK'.
Detach the Database
1. Right-click the database, select 'All Tasks', and then click 'Detach Database…'.
2. At this point the current number of connections to the database will be displayed. If there are any connections, they must be cleared before the database can be detached. Click 'Clear'. You will then be prompted with 'This will end all active transactions in this database which is required before the database can be detached. Is it OK to proceed?' Click 'OK'. The next prompt is regarding notifying users. It will ask 'Do you want to notify the currently connected users that their sessions in the database will be ended?' I always click 'No' for web applications. And then click 'OK' to detach the database.
3. At this point the database is detached (it will not appear in Enterprise Manager).
Next, you'll need to copy the data file (.mdf) and transaction log (.ldf) file to the new server. By default, SQL server will create databases and put these files in the same directory (it's usually Program FilesMicrosoft SQL ServerMSSQLData). However, for performance gains, this may be changed so the transaction log file is put on another hard drive. Be sure to check the new SQL server to see how it is setup. If the transaction log files are setup on a different hard drive, it should be copied there and the data file should be put in its appropriate directory. And, when attaching the database, be sure the paths to the files are correct.
Read the Rest of the Article
About the Author:
Desirée Harris is a support specialist with ORCS Web - a company that provides managed hosting services for clients who develop and deploy their applications on Microsoft Windows platforms. |
