Page 1 of 4312345678910...2025303540...Last »

SQL Server Backup Files Cleanup

I learned something interesting today. Something so simple yet crucial. Alright, let me jump straight on to it.

After going live with GP2015R2, as part of SQL maintenance tasks, I created daily backup schedule in SQL Server. Client’s backup retention policy is 3 prior days. So I created a “Maintenance Cleanup Task” to remove all backup files that are older than 3 days.

All good. Only that, it didn’t work. And we realised that only yesterday. Bummer. Thankfully, it was a new server so we had plenty of space. And size of DBs are quite small. So I could see backup files dating yesterday. Which is nice.

I had to figure out what’s going wrong all this time. It’s a fairly simple setup. Nothing complex. Something must be wrong. I opened the maintenance task definition window. Shown below:

Screen Shot 2016-02-23 at 8.55.04 AM.png

Looks perfectly alright to me. Isn’t it? But nope. Something makes this task fail every night.

When I looked at this post, Maintenance Cleanup Task (Maintenance Plan), on Microsoft MSDN site, I could not get much help from. It was good, detailed, but not good enough to help me why my task fails every night.

I then did something that I thought is weird, but turned out to be the solution.

I changed the File extension value from .bak to just bak, as shown below:

Screen Shot 2016-02-23 at 8.55.04 AM.png

Saved the definition and ran the task manually to check if it worked.

Voila… It worked…!!!

Those who are reading this and thinking about why I am blogging something as simple as this (as if I found the god particle), well in all honesty, I had absolutely no idea about this till now. Just thought I would share this, as I always do. So please be nice on me.

VAIDY

Filed under: #MSDYNGP, DBA, SQL, SQL Administration, SQL Server, SSMS, Troubleshooting, Uncategorized

More:
SQL Server Backup Files Cleanup

February 23, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 116

View To Return Sales Orders (Work Status) Requiring … – azurecurve

CREATE VIEW uv_AZRCRV_SalesOrdersToBeAssembled AS /* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons … MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn …

Continue Reading:
View To Return Sales Orders (Work Status) Requiring … – azurecurve

February 15, 2016 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 63

Copy Fiscal Calendar To All Companies | azurecurve

Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). … MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile …

Continue reading here:
Copy Fiscal Calendar To All Companies | azurecurve

January 8, 2016 · Ian Grieve · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 134

Happy New Year 2016

To the GP Community:

Happy New Year 2016!

This year is slated with lot of interesting releases for GP impending. I am absolutely as excited as all of you.

Let’s wish this year be an excellent year for Dynamics GP and its success.

VAIDY

Filed under: #MSDYNGP, New Year, Off-Topic, Uncategorized

See the original post:
Happy New Year 2016

January 1, 2016 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 150

New Year eBook Sale at azurecurve Publishing | azurecurve

MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s …

Visit site:
New Year eBook Sale at azurecurve Publishing | azurecurve

December 31, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 132

Navigation List Error: “Cannot insert the value NULL … – azurecurve

MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s …

Read the article:
Navigation List Error: “Cannot insert the value NULL … – azurecurve

December 23, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 96

Batch Command To Restart Hyper-V | azurecurve

MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s …

See the original post:
Batch Command To Restart Hyper-V | azurecurve

December 10, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 134