Results 1 to 4 of 4

Thread: How to take sql server 2008 Backup

  1. #1
    Join Date
    Oct 2008

    How to take sql server 2008 Backup

    I wanted to take the backup of SQL server 2008, this is the database i have maintained for keeping employee details, and it would be beneficial for me if i take a backup of whole of data Please guide how should i done that.


  2. #2
    Join Date
    Feb 2009

    Re: How to take sql server 2008 Backup

    Windows can backup Microsoft SQL Server databases running on your computer to your IBackup account. It can backup SQL Server database to local hard disk or network storage device. everal options are available for defining your backup and recovery model and your choices will determine the reliability and the amount of data loss your company can acceptably incur. It takes advantage of the embedded capabilities in Microsoft SQL Server's backup and restore functions to ensure fast and reliable backup and restore.

  3. #3
    Join Date
    Dec 2008

    Re: How to take sql server 2008 Backup

    SQL Server databases may be backed up to either a disk or tape media. Backup may be performed through SQL Server Enterprise Manager or a Transact-SQL command. In fact, we will just talk about how to restore database that is in full recovery model. high performance compression technology allows companies to reduce storage requirements, reduce backup times and speed recovery duration, while maintaining complete control over the backup and recovery process.

  4. #4
    Join Date
    Jan 2009

    Re: How to take sql server 2008 Backup

    Following are the three database recovery model options are. Simple, Full, Bulk Logged Recovery model. If the tape to which the backup is being written fills up, SQL Server Enterprise Manager pops a dialog box and prompts for the next tape. The appropriate choice depends on your applications and the criticality of your data. These settings can be configured either through Enterprise Manager or through T-SQL using the ALTER DATABASE command. This is in contrast to disk backups, where inadequate disk space terminates the backup operation.

Similar Threads

  1. Replies: 1
    Last Post: 27-12-2011, 10:43 PM
  2. Windows server 2008 - What theres no tape backup!
    By w-cubed in forum Windows Server Help
    Replies: 10
    Last Post: 02-02-2011, 12:11 AM
  3. Backup Exchange 2007 on Windows Server 2008
    By Atsushi in forum Windows Software
    Replies: 5
    Last Post: 20-11-2010, 03:34 AM
  4. Install Windows Server Backup in Windows Server 2008
    By kattman in forum Guides & Tutorials
    Replies: 6
    Last Post: 08-01-2010, 03:04 PM
  5. Replies: 1
    Last Post: 06-05-2009, 09:09 PM

Posting Permissions

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