motioneye
asked on
T-sql backup database statement
Below is my backup statement:
BACKUP DATABASE [Master] TO [MasterDevice] WITH
RETAINDAYS = 5, NOFORMAT, INIT, NAME = N'Master-FullBackup', SKIP, NOREWIND,
NOUNLOAD, STATS = 10
GO
I need to know if after5 days will the file get initialized and contains only backup set <2 days? Can I know what is mean with an option SKIP,NOREWIND,NOUNLOAD
BACKUP DATABASE [Master] TO [MasterDevice] WITH
RETAINDAYS = 5, NOFORMAT, INIT, NAME = N'Master-FullBackup', SKIP, NOREWIND,
NOUNLOAD, STATS = 10
GO
I need to know if after5 days will the file get initialized and contains only backup set <2 days? Can I know what is mean with an option SKIP,NOREWIND,NOUNLOAD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.