How to Backup and Restore a Database in SQL Express

[@TheVideo2002]

3:15 I'm only able to do a backup in drive C:\ Is possible to do a backup in another server in the network, using SQL Express?

[@seanmackenziedataengineering]

Yes this is generally the case (you can use other mapped drives like D: F: etc). Generally, my process for network drives is to run a windows scheduled task that moves the backup file to the network after it is created (literally a one-liner PS or cmd script). Or, you can have a folder as a service like Dropbox or Sync that you back up into and the service takes care of syncing to the cloud etc. You can use a UNC path to create the backup in a network folder but then you have to work with permissions. Make sure the SQL Server account has all the necessary permissions on the remote computer.

[@ballaomer6738]

Great tutorial sir , appreciate it ❤

[@seanmackenziedataengineering]

Glad you liked it!

[@iacobradu2899]

Hey, nice video. Its mandatory to use master before doing the backup?

[@seanmackenziedataengineering]

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.

[@sudarsonoliyis]

Can I run the sql from my access , so backup can be done everyday from my database?

[@seanmackenziedataengineering]

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.

[@sudarsonoliyis]

@@seanmackenziedataengineering thanks for the insight, just done integrate your backup sql code to my database and it works

[@seanmackenziedataengineering]

@@sudarsonoliyis nice!