Backing Up Microsoft SQL Server with Ahsay Using SQL Server's Native Backup Tools Workaround

A point-and-click guide — all menus and buttons, no code.

Option 1 — Make a backup right now

Use this when you just want a one-off backup on demand.

1. Open SQL Server Management Studio and click Connect to sign in to the server.
2. On the left, click the small arrow next to Databases to expand the list.
3. Right-click the database you want → hover Tasks → click Back Up…
4. In the window that opens, leave Backup type set to Full.
5. Under Destination, click the file that’s listed and click Remove. Then click Add…, type your folder and a file name (for example D:\SQLBackups\YourDatabase.bak), and click OK.
6. Click OK at the bottom. You’ll see “The backup completed successfully.” That file is what Ahsay picks up.

Option 2 — Run it automatically every night

Use this to set it once and let SQL Server back itself up on a schedule — still all wizard, no typing.

1. On the left, expand Management.
2. Right-click Maintenance Plans → Maintenance Plan Wizard, then click Next.
3. Give it a name like Nightly SQL Backup. Click Change… to set the schedule (for example every day at 1:00 AM), then Next.
4. Tick Back Up Database (Full). To also tidy up old files, tick Maintenance Cleanup Task too. Click Next.
5. Pick your database from the dropdown, then set the destination to your backup folder (for example D:\SQLBackups). Click Next.
6. If you added cleanup, tell it to delete backup files older than a couple of days.
7. Keep clicking Next, then Finish. SSMS builds the whole schedule for you.