Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to take sql server 2008 Backup

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-08-2009
Member
 
Join Date: Oct 2008
Posts: 115
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.

Thanks

Reply With Quote
  #2  
Old 06-08-2009
Member
 
Join Date: Feb 2009
Posts: 105
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.
Reply With Quote
  #3  
Old 06-08-2009
Member
 
Join Date: Dec 2008
Posts: 128
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.
Reply With Quote
  #4  
Old 06-08-2009
Member
 
Join Date: Jan 2009
Posts: 150
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to take sql server 2008 Backup"
Thread Thread Starter Forum Replies Last Post
Migrate AD , DNS and DHCP from a Virtual Server 2008 to a New Server 2008 hassen Active Directory 1 27-12-2011 10:43 PM
Windows server 2008 - What theres no tape backup! w-cubed Windows Server Help 10 02-02-2011 12:11 AM
Backup Exchange 2007 on Windows Server 2008 Atsushi Windows Software 5 20-11-2010 03:34 AM
Install Windows Server Backup in Windows Server 2008 kattman Guides & Tutorials 6 08-01-2010 03:04 PM
Difference between Windows Server 2008 / SBS 2008 / EBS 2008 / SBS2003 kyosang Small Business Server 1 06-05-2009 09:09 PM


All times are GMT +5.5. The time now is 07:28 AM.