I have a Microsoft SQL Server 2005 DB server. In the DB server, I have around 250 user databases. I have to take a back up of all these databases. Since, manually taking backup consumes lot of time, I am looking for a Batch script or DB script which will automatically take the backup of all the 250 databases. Can anyone please help on this?
Sql-server – Taking backup of all the databases in SQL Server
backupsql serversql-server-2005
Related Question
- Options to Include with mysqldump for Hybrid Databases Backup
- SQL Server 2005 – Backup All Databases into One .bak File
- Sql-server – Script to backup all databases
- SQL Server Backup – How to Take Full and Differential Backups of All Databases
- TSQL Solution – Backup All Databases on All Server Instances
- SQL Server – How to Backup All Databases in the Same Place
- Sql-server – SQL Full Backup job is taking too long to complete
Best Answer
Step 1: Create a procedure that are given below.
Step 2: Execute the above procedure.
You can also schedule this procedure. This procedure is tested hopefully it will help.