hi...
i want to take the backup of the DB..
in my system there are two DB employee and department
now using SSIS how can i take the backup of the employee DB..
i'm new to this SSIS..
i'm using sql server2008 enterprise edition.
please help me...
Printable View
hi...
i want to take the backup of the DB..
in my system there are two DB employee and department
now using SSIS how can i take the backup of the employee DB..
i'm new to this SSIS..
i'm using sql server2008 enterprise edition.
please help me...
You don't need ssis to backup db, just read 'How to: Create a Full Database Backup (Transact-SQL)' and 'How to: Back Up a Database (SQL Server Management Studio)' in books online.
All you need to do is Right Click on top of the DB --> go to Tasks --> Backup.
Or if you prefer to use T-SQL, just run this command.
Quote:
BACKUP DATABASE EmployeeDB TO DISK='C:\MyBackupFolder\EmployeeDB.bak'
DbDefence - transparent database encryption and SQL protection
SSIS is a tool that can be used to perform a broad range of data migration tasks. However, there are easier ways to backup your databases.
If you don’t have so much experience with MS-SQL backups you should try “SQL Backup and FTP” http://www.sqlbackupandftp.com/. It is extremely easy to use and provides additional features like uploading backups to FTP repositories, schedule backup jobs, etc.