BACKUP DATABASE AdventureWorks
TO DISK = 'C:\SQLData\AdventureWorks_compressed.bak'
WITH COMPRESSION, INIT, STATS = 10
***************************
It compresses data up to 75% and reduction in time as well
Now time has come to remove backup pro and lite speed.
Restore doesn't need any extra command.
***************************
No comments:
Post a Comment