What is the best way to recreating the operating system and SQL with data on the new drives? I do not want lose connectivity with the rest of the servers or lose any information such as container sizes of the database, names of the SQL server or the data itself.
- Regardless of the option you select, build a short task list and test the process in a test environment prior to executing in the production environment.
- Backup the existing server, rebuild the server with the additional disks, install Windows and SQL Server and then restore the databases.
- Purchase a internal cage or external array to house the new drives and move the databases to these new drives.
- Purchase a new server and have your existing server demoted to a backup production server or a dedicated test or development server.
I think this is a good topic and will consider writing a tip on this topic. Thank you!
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ... Continue Reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ... Continue Reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.