Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
sql backup process
generic
Member Posts: 511
Hello
A client of mine has setup backup process the following way.
Doing a full backup nightly
and doing differential backup hourly.
They are in process of creating a new test environment and I suggested to do a sql backup and restore, which would be faster than native.
One of their IT wrote back that we should make a copy of the db instead of backup, because it will break the backup cycle they have setup. Is this true?
How does a separate backup effect their nightly and differential backup they have scheduled?
Thanks.
A client of mine has setup backup process the following way.
Doing a full backup nightly
and doing differential backup hourly.
They are in process of creating a new test environment and I suggested to do a sql backup and restore, which would be faster than native.
One of their IT wrote back that we should make a copy of the db instead of backup, because it will break the backup cycle they have setup. Is this true?
How does a separate backup effect their nightly and differential backup they have scheduled?
Thanks.
0
Comments
In fact taking backups can break the backup chain. The reason is that the diff. backup is the diff to the last full backup. If someone else just takes a full backup you are in big troubles.
But there is a parameter "copy_only" which does just that.
More details here:
http://msdn.microsoft.com/en-us/library/ms191495.aspx
Hope this helps
Thomas
So from SMS when doing tasks->backup. I need to make sure "Copy only Backup" is checked.
What is the recovery model of the database? If it is FULL, then Full and transaction logs backups should be considered the minimum. With the addition of differentials as an option.
I would also consider 1 hour a rather short timeframe for a differential backup.
That was my first thought also.
My second thought was "why didn't the IT guy suggest this?" :-k