<div>
incidentally, you can use the SQL extended sp xp_delete_file to delete backup files directly from within SQL.
</div>


incidentally, you can use the SQL extended sp xp_delete_file to delete backup files directly from within SQL.

<div>
You can do easily using SSIS packages.<br />
There are some task to maintain SQL Server objects and else more.
</div>


You can do easily using SSIS packages.
There are some task to maintain SQL Server objects and else more.

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I am trying to create a script that will delete an existing back up at a specific location (a)<br />
and Create a back up of the database to the same location (a)<br />
<br />
Also trying to achieve the same with restoring the database
</div>
</div>


I am trying to create a script that will delete an existing back up at a specific location (a)
and Create a back up of the database to the same location (a)

Also trying to achieve the same with restoring the database

sql database back up using a .bat file

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.