It is not mandatory for the backup, but more of a best practices thing. When you start backing up, restoring, adding & removing logins and permissions, you'll be changing context all the time so it is good to explicitly say where you want to "work" before performing script operations.
You can, using an ADO connection. Good topic for a video actually! One way that people do a daily backup is to use Windows Scheduler to call a simple script to execute the batch each day/hour/week/etc This way, if your Access db is not open, it will still run the backup.
Hey, nice video. Its mandatory to use master before doing the backup?
It is not mandatory for the backup, but more of a best practices thing. When you start backing up, restoring, adding & removing logins and permissions, you'll be changing context all the time so it is good to explicitly say where you want to "work" before performing script operations.
Great tutorial sir , appreciate it ❤
Glad you liked it!
Can I run the sql from my access , so backup can be done everyday from my database?
You can, using an ADO connection. Good topic for a video actually! One way that people do a daily backup is to use Windows Scheduler to call a simple script to execute the batch each day/hour/week/etc This way, if your Access db is not open, it will still run the backup.
@@seanmackenziedataengineering thanks for the insight, just done integrate your backup sql code to my database and it works
@@sudarsonoliyis nice!