Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Snapshot of SQL database on a SAN

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-06 : 08:36:08
Owen writes "I am working with a reseller who is trying to find a solution for a customer with a SQL database. Their client's objective is to create real-time image of a Microsoft SQL database every hour "without performing a net stop on the SQL database". Is that possible? Is there a SAN solution (hardware & software) that can address this need? Thanks."

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-02-06 : 09:28:29
BACKUP DATABASE and BACKUP LOG ... tell you reseller to hire a SQL Server consultant to design and implement a backup/recovery scheme the customer.

Even if you could "snapshot" the SQL files while they were live, after a disaster you couldn't do anything with them.

Jay White
{0}
Go to Top of Page
   

- Advertisement -