At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
USE OldDatabase BACKUP DATABASE OldDatabase TO DISK = 'C:\backups\7-14.bak' WITH NAME = 'Full Backup of OldDatabase 7-14'; GO USE master RESTORE DATABASE NewDatabase FROM DISK = 'C:\backups\7-14.bak' WITH MOVE 'OldDatabase' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\NewDatabase.mdf', MOVE 'OldDatabase_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\NewDatabase_log.ldf', REPLACE GO ;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.