The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
BACKUP DATABASE PRD TO DISK='C:\temp\prd_backup.bak" with COMPRESS
Open in new window
RESTORE DATABASE TST
WITH MOVE 'LogicalDataName' to D:\datafiles\tst.mdf',
MOVE 'LogicalLogName' to L:\logfiles\tst.mdf'
select name, physical_name from sys.database_files
RESTORE DATABASE ZTEST
MOVE 'GPSTWODat' to 'S:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\GPSTWODat.mdf'
MOVE 'GPSTWOLog' to 'S:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\GPSTWOLog.ldf'
Author Closing Comment
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!