RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

SQL Server Compressed Backup

Activation with 2 ways:> from console> from sql command //Compression backup activationEXEC sys.sp_configure 'backup compression default', '1'GORECONFIGURE WITH OVERRIDEGO / * BACKUP SYSTEM DATABASE AND PRODUCTION DATABASE */Backup Parameters> SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10Backup Check> with stored procedure /* SYSTEM DATABASE */BACKUP DATABASE [master] TO  DISK = N'W:\TSMFileBackup\master.BAK' WITH NOFORMAT, INIT,  NAME = N'master-Full Database B 
Leggi tutto il post...
Categoria: Dynamics NAV 2013
domenica, 12 mag 2013 Ore. 22.19

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003