dcsimg
Results 1 to 5 of 5

Thread: how to take backup of the DB

  1. #1
    Join Date
    Oct 2010
    Posts
    24

    how to take backup of the DB

    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...

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    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.

  3. #3
    Join Date
    Apr 2011
    Posts
    2
    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.
    BACKUP DATABASE EmployeeDB TO DISK='C:\MyBackupFolder\EmployeeDB.bak'



    DbDefence - transparent database encryption and SQL protection

  4. #4
    Join Date
    May 2011
    Posts
    2

    Smile

    Quote Originally Posted by vinayak.v View Post
    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 ca use a gui tool, to backup your databases, synchronized it to another one and so on,there are alot of tools out there that can help,personally i'm using DbSchema.
    Attached Images Attached Images

  5. #5
    Join Date
    Jun 2011
    Posts
    3
    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 dont 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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •