<div>
<div class="content wysiwyg-content">
We are getting a new server and we need to transfer a 15g database to the new one. &nbsp;What would be the fastest way to do this....using the copy database wizard or doing a backup and restore? &nbsp;Also can this be done during production or will it have to be after hours?<br />
<br />
Thanks
</div>
</div>


We are getting a new server and we need to transfer a 15g database to the new one.  What would be the fastest way to do this....using the copy database wizard or doing a backup and restore?  Also can this be done during production or will it have to be after hours?

Thanks

Use copy database wizard or backup and restore on sql server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.