Hi consider that I have 3 tables(Order and OrderDetials and Products) and each these entities has attributes and I have saved some data in those tables and now I want to save all those data and keep them some where and then change some value of those attributes and start a new work with them how can I do that can I put those useless data on the CD?
A:
Use "BACKUP" command.
BACKUP DATABASE 'YourDatabase' TO DISK = '~/backup/YourDatabase.BAK'
For more details see. http://technet.microsoft.com/en-us/library/ms186865.aspx
Zimbabao
2010-07-31 06:25:44
aha thanks a lot
Johanna
2010-07-31 06:48:45
also it means that when I back up those data then I can do what ever I want to the new data with out changing those last data that I have back up them ,is it correct?
Johanna
2010-07-31 07:10:37
Yes. Correct. When ever you want want old data , just restore from backup.
Zimbabao
2010-08-01 13:07:22