January 19, 2011 at 1:32 pm
In your opinion, what is the best way to backup SQL servers. I am talking about complete backup (more like an image). I want to be able to use the backup to recover the server (not just the database), in case of hard disk failure, etc.
I noticed that there is a utility called "Windows Server Backup" that comes with the SQL server OS. Do you recommend using it? And if yes, how is it going to be used to recover the server. Assuming that I am keeping the backup files at a remote storage.
I have both SQL 2003 and SQL 2008 servers.
Thanks
January 19, 2011 at 1:58 pm
SQL Server 2003? No such version.
Backup your databases using a database backup tool. Native backup or a 3rd party tool like SQLBackup (Redgate) or Litespeed (Quest). Do not back databases up with system backup tools
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2011 at 2:58 pm
I want to back the whole system. Similar to imaging the Hard disk. I know I can use Norton ghost, as an example, to image workstations. But what software to use to image servers?
Thanks,
January 19, 2011 at 3:08 pm
Not for SQL backups. Not if you actually want them restorable.
As for system backups, no idea, I'm not a system administrator.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2011 at 3:13 pm
I am doing database backup already. But I need to do server backup (image the drives)?
January 20, 2011 at 12:34 am
The only way to backup the entire server would be to ghost it. The windows backup tool will backup folders and system information, which you can use to restore to a newly built server, I'm guessing you are using windows 2003 and not sql 2003 because that product doesn't exist.
if this is just a sql server and doesn't have any other role, it isn't that hard to bring up a win03 server and put sql on it. Another solution you might want to try is to sysprep the existing server; that's what I did to bring up all my win08 r2 + sql 2008 r2 servers on hyper-v.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
January 20, 2011 at 4:40 am
techzone12 (1/19/2011)
I noticed that there is a utility called "Windows Server Backup" that comes with the SQL server OS.
The Windows server backup product built in to Windows 2008 is specifically designed to backup the server and its system state, so yes you could use this to recover the Windows OS and config in the event of hard disk failure.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply