April 8, 2021 at 1:51 pm
Without a 3rd party tool, what's the best way to backup SQL Express, not having SQL Agent ?
A Windows Task Scheduled to run a backup script, and delete old backups ?
April 8, 2021 at 3:36 pm
You have to be able to schedule 'something' - so you need a tool that schedules and runs jobs. Since SQL Server Express does not have the agent then you are left with Task Scheduler in windows.
As to what can be used to run that code - Powershell would be a good option, and better yet - download dbatools (https://dbatools.io/) and use their components in a PS script to handle backups.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 8, 2021 at 4:02 pm
Could you use SQL Developer Edition? If it's business prod, you can't, but if it's just something you're doing on your own, you can. And that edition has full capabilities.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
April 8, 2021 at 4:09 pm
Powershell and a Windows Scheduled Task is one method yes. Some prefer to use a different scheduling tool that is more "user friendly"; there are plenty out there if you have a search.
As for using Powershell, as Jeffrey mentioned, DBA Tools is a really nice 3rd party module. The SqlServer module also has the Backup-SqlDatabase command, if you prefer non-third parties modules.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 14, 2021 at 11:46 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply