Msft Access, SQL Server support for Volume ShadowCopy Service (VSS)

[Ken L]

Can anyone point me at some reference material on Microsoft Access' support
for the Volume ShadowCopy Service in WinXP Pro and Win2003 Server, please?
I am particularly interested in any information on backup of open databases
and whether the standard Microsoft OS software-based snapshot copy support
provides more than "crash-consitent" backup support (i.e., VSS "Writer"
support) for Access / SQL databases at various software release levels.

If Access doesn't support VSS, can anyone tell me whether MSDE (aka SQL
Server Lite) has VSS "Writer" support? What versions of SQL Server
provide VSS support for open databases?

Please respond to the newsgroup. Thanks in advance for any assistance.

Ken

 

[Steen Persson (DK)]

Can anyone point me at some reference material on Microsoft Access' support
for the Volume ShadowCopy Service in WinXP Pro and Win2003 Server, please?
I am particularly interested in any information on backup of open databases
and whether the standard Microsoft OS software-based snapshot copy support
provides more than "crash-consitent" backup support (i.e., VSS "Writer"
support) for Access / SQL databases at various software release levels.

If Access doesn't support VSS, can anyone tell me whether MSDE (aka SQL
Server Lite) has VSS "Writer" support? What versions of SQL Server
provide VSS support for open databases?

Please respond to the newsgroup. Thanks in advance for any assistance.

Ken

I don't know about Access, but maybe this link can help you with MS SQL
Server

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlwriter.mspx