Can anyone help me with a script to take a full or complete backup of all databases once in a week and to take differential backups daily. ?
I believe @Les H has already answered and Yes, ola's script should do the work here without any issues.
However as per the MS Link you can also do something like:
Use SQL Server Management Studio Express or Sqlcmd to create the following stored procedure in your master database named
sp_BackupDatabases. The script to create the SP is available on the link.
create a batch file that will execute the above SP, also specifying the location of backup and its mode, that is Full , differential or log.
Schedule a job by using Windows Task Scheduler to execute the batch file that you created in step 2
You should look at Ola Hallengren's scripts
The FAQ has examples on using these scripts with SQL Express.
Why don't you use one of many third-party tools? You can set up scheduled backups as you need full backup once a week and differential backups daily.
So test them and chose the best one that you need.