snapshot backup on SAN for MS SQL Server

#1

Could someone please point out to the steps required to set up
snapshot backups of live MS SQL databases residing (about a 100 in
number) on a single SAN. We do not wish to bring down the database.
Currently we have Netbackup 12.0 and 12.5 software and also have the
additional Netbackup module prescribed by the vendor for snapshop
backup. The transaction logs are placed on a different hard drive than
the database itself, although both transaction logs and databases
reside on the same SAN.
Our current backup method is to first bring SQL down, then take a
snapshopt of the actual SQL files. The recover takes hours.
Any ideas to improve this situation are greatly appreciated!

#2

Just in case - we are using MS SQL 2005.

On Feb 5, 9:19*am, Toynbee <ybhattacha... (AT) gmail (DOT) com> wrote:

Quote:

Could someone please point out to the steps required to set up
snapshot backups of live MS SQL databases residing (about a 100 in
number) on a single SAN. We do not wish to bring down the database.
Currently we have Netbackup 12.0 and 12.5 software and also have the
additional Netbackup module prescribed by the vendor for snapshop
backup. The transaction logs are placed on a different hard drive than
the database itself, although both transaction logs and databases
reside on the same SAN.
Our current backup method is to first bring SQL down, then take a
snapshopt of the actual SQL files. The recover takes hours.
Any ideas to improve this situation are greatly appreciated!

#3

What kind of SAN do you have?
--
Thanks,
Brian Henderson

"Toynbee" wrote:

Quote:

Just in case - we are using MS SQL 2005.

On Feb 5, 9:19 am, Toynbee <ybhattacha... (AT) gmail (DOT) com> wrote:
Could someone please point out to the steps required to set up
snapshot backups of live MS SQL databases residing (about a 100 in
number) on a single SAN. We do not wish to bring down the database.
Currently we have Netbackup 12.0 and 12.5 software and also have the
additional Netbackup module prescribed by the vendor for snapshop
backup. The transaction logs are placed on a different hard drive than
the database itself, although both transaction logs and databases
reside on the same SAN.
Our current backup method is to first bring SQL down, then take a
snapshopt of the actual SQL files. The recover takes hours.
Any ideas to improve this situation are greatly appreciated!

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

snapshot backup on SAN for MS SQL Server

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

snapshot backup on SAN for MS SQL Server - 02-05-2010 , 08:19 AM

Re: snapshot backup on SAN for MS SQL Server - 02-05-2010 , 08:20 AM

Re: snapshot backup on SAN for MS SQL Server - 02-06-2010 , 09:57 PM