Script recipe of the week: how to copy an opened file

re: Script recipe of the week: how to copy an opened file

Yoshihiro Kawabata — Wed, 05 Jan 2005 14:42:00 GMT

Very useful script !.
I sucess to do it.

but, If SQL Server service are running,
CopyWithVss is failed.

ERROR Messages is:
----
ERROR: Selected writer 'MSDEWriter' is in failed state!
- Status: 8 (VSS_WS_FAILED_AT_PREPARE_SNAPSHOT)
- Writer Failure code: 0x800423f4 (<Unknown error code>)
- Writer ID: {f8544ac1-0611-4fa5-b04b-f7ee00b03277}
- Instance ID: {ef567f78-4f42-49be-bb1c-2386a7f489cf}
----

I want to copy Database/Log Files by this script, because I'm MVP for SQL Server.

Regards,

re: Script recipe of the week: how to copy an opened file

Adi Oltean — Wed, 05 Jan 2005 19:42:00 GMT

>>> ERROR Messages is:
----
ERROR: Selected writer 'MSDEWriter' is in failed state!
- Status: 8 (VSS_WS_FAILED_AT_PREPARE_SNAPSHOT)
- Writer Failure code: 0x800423f4 (<Unknown error code>)
- Writer ID: {f8544ac1-0611-4fa5-b04b-f7ee00b03277}
- Instance ID: {ef567f78-4f42-49be-bb1c-2386a7f489cf}

Intersting - this should not happen. Are there any VSS errors in the Application event logs? If yes, please cut & paste them in your reply.

Note that with SQL, if the database and the logs are on different volumes, then you might want to change the script to snapshot simultaneously both the database and the log volumes. If everything is on the same volume, it should still work.

By the way, the VSS SDK contains a set of test VSS scripts that can be used to backup and restore a SQL/MSDE database, and then verify that the restore was succesful.

Thanks, Adi

re: Script recipe of the week: how to copy an opened file

Yoshihiro Kawabata — Wed, 05 Jan 2005 21:29:00 GMT

Hello, Adi

Application Event log:
Type: ERROR
SOURCE: VSS
Category: non
Event: : 6004
User: N/A
Description:
"Sqllib ERROR: Database testdb is not simple".
** I use Japanese Environment (OS, SQL Server).
Therefore, real errormessage is in japanese,

If i detach database 'testdb' by SQL Server Enterprise Manger, Or If I change 'testdb' recovery mode from 'full' to 'simple',
CopyWithVSS command do complete !.

Therefore,
if any database's recovery mode is not simple, CopyWithVSS fail.

Regards,

re: Script recipe of the week: how to copy an opened file

Adi Oltean — Wed, 05 Jan 2005 22:48:00 GMT

I have two more questions: Do you have XP or Windows Server on your system? Also, is this a SQL Server 2000 database?

Thanks, Adi

re: Script recipe of the week: how to copy an opened file

Yoshihiro Kawabata — Thu, 06 Jan 2005 13:02:00 GMT

Hello, Adi

Yes, I have
Windows XP Pro + SP2 (Japanese Edition)
Windows Server 2003 Std (Japanese Edition)
SQL Server 2000 Std SP3a (Japanese Edition)

and, this problem seems to relate below kb.

*Error 800423f4 appears in the backup log file when you back up a volume by using the Volume Shadow Copy service in Windows Server 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;828481

and Windows Server 2003 SP1 will fix this problem.
-- how about XP ?

Regards,

re: Script recipe of the week: how to copy an opened file

Adi Oltean — Fri, 07 Jan 2005 00:55:00 GMT

I see... this is a known problem with VSS & SQL on Windows XP.

On Windows XP, the MSDE writer for VSS works only with SQL/MSDE databases with the Simple recovery model.

But on Windows Server 2003, the writer should work with databases in full recovery model too, as long as the VSS backup is in component mode (from VSHADOW.EXE), not in volume mode (like from NTBackup.exe).

Attack of the clones: how to assign shadow copy to a drive letter or directory

AntiMail — Fri, 21 Jan 2005 05:37:00 GMT

Attack of the clones: how to assign shadow copy to a drive letter or directory

AntiMail — Fri, 21 Jan 2005 05:41:00 GMT

re: Script recipe of the week: how to copy an opened file

Diego — Sat, 22 Jan 2005 08:15:00 GMT

Will work for lotus(domino server) databases?

re: Script recipe of the week: how to copy an opened file

Adi Oltean — Sat, 22 Jan 2005 23:42:00 GMT

It depends. The recommended procedure is to have a VSS writer that listens for backup events (shadow copy creation events) and flushes the database in order to minimize the recovery time.

If there is no writer involved, then the contents of the shadow copy will look as if the machine was suddenly powered off. If Lotus can recover after a sudden reboot (as anyone would expect) then, yes, you can use this technique for Lotus databases.

Using shadow copies to steal the SAM

DCortesi . blog — Tue, 22 Mar 2005 18:35:00 GMT

As I was enjoying a fine dinner of Lipton Italian Sides one night, I came across Adi's post on how to copy an open file with shadow copies. Not bad, I thought, and stored that little nugget of knowledge away for when I might need to do just that.

A...

I Want to Backup Both My Mac and PC at Nerhood Weblog

I Want to Backup Both My Mac and PC at Nerhood Weblog — Mon, 03 Jul 2006 19:50:16 GMT

PingBack from http://nerhood.homeip.net/wordpress/archives/2006/07/03/i-want-to-backup-both-my-mac-and-pc/

Volume Shadow Copy: your way to copying locked files

The private life of Alex Thissen — Wed, 06 Dec 2006 23:09:44 GMT

And you thought it couldn't be done: copying locked files, such as your .pst file from Outlook, while

Volume Shadow Copy: your way to copying locked files

Alex Thissen Weblog Build 1.15.10.1971 — Wed, 06 Dec 2006 23:56:15 GMT

And you thought it couldn't be done: copying locked files, such as your .pst file from Outlook, while

Netweb links for 2007-08-06 «

Netweb links for 2007-08-06 « — Mon, 06 Aug 2007 10:18:53 GMT

PingBack from http://netweb.wordpress.com/2007/08/06/links-for-2007-08-06/

Complete Virtual Machine Backups with Mere Minutes of Downtime

John Robbins' Blog — Mon, 08 Oct 2007 04:39:07 GMT

Last week, I completely virtualized my life. Well, at least my server life is all virtualized. I'd been

Copiar fitxers oberts en Windows * L???home dibuixat

Copiar fitxers oberts en Windows * L???home dibuixat — Mon, 03 Mar 2008 13:41:25 GMT

PingBack from http://caballe.cat/wp/2008/03/03/copiar-fitxers-oberts-en-windows/

atomice.com » Blog Archive » Bare Metal Disaster Recovery for Windows Vista Home: How to Backup

Tue, 01 Apr 2008 15:41:20 GMT

PingBack from http://www.atomice.com/blog/?p=26

how to copy files

how to copy files — Sat, 07 Jun 2008 16:33:57 GMT

PingBack from http://xaviernewssite.k2free.com/howtocopyfiles.html

script dp0

script dp0 — Mon, 23 Jun 2008 11:22:53 GMT

PingBack from http://isabell.ranchcredit.com/scriptdp0.html

vshadow exe msdn

vshadow exe msdn — Wed, 09 Jul 2008 14:34:19 GMT

PingBack from http://jaydendailynews.iifree.net/vshadowexemsdn.html

Backup Data to Remote Server for DR - ShoreTel Forums

Backup Data to Remote Server for DR - ShoreTel Forums — Sun, 24 Aug 2008 10:05:29 GMT

PingBack from http://www.shoretelforums.com/forums/administrators/2048-backup-data-remote-server-dr.html#post6144

Shadow Copy ???? ?????????????????? ???????????? « PowerShell ?? ???????????? ??????????????

Sun, 30 Nov 2008 11:19:32 GMT

PingBack from http://xaegr.wordpress.com/2008/11/30/shadow-copy-%d0%b8%d0%b7-%d0%ba%d0%be%d0%bc%d0%b0%d0%bd%d0%b4%d0%bd%d0%be%d0%b9-%d1%81%d1%82%d1%80%d0%be%d0%ba%d0%b8/

backup partizione nella partizione su un file | hilpers

backup partizione nella partizione su un file | hilpers — Sun, 18 Jan 2009 15:58:12 GMT

PingBack from http://www.hilpers.it/2742093-backup-partizione-nella-partizione-su

Logs de seguridad | hilpers

Logs de seguridad | hilpers — Tue, 20 Jan 2009 22:34:01 GMT

PingBack from http://www.hilpers-esp.com/247319-logs-de-seguridad

Outlook PST Files - Locked while copying | keyongtech

Outlook PST Files - Locked while copying | keyongtech — Thu, 22 Jan 2009 13:07:03 GMT

PingBack from http://www.keyongtech.com/1672650-outlook-pst-files-locked-while

Kopiowanie otwartych/zablokowanych plik?w | hilpers

Kopiowanie otwartych/zablokowanych plik?w | hilpers — Fri, 23 Jan 2009 07:39:33 GMT

PingBack from http://www.hilpers.pl/412024-kopiowanie-otwartych-zablokowanych-plikow

Antimail Script recipe of the week how to copy an opened file | Paid Surveys

Antimail Script recipe of the week how to copy an opened file | Paid Surveys — Fri, 29 May 2009 22:59:43 GMT

PingBack from http://paidsurveyshub.info/story.php?title=antimail-script-recipe-of-the-week-how-to-copy-an-opened-file

Antimail Script recipe of the week how to copy an opened file | Menopause Relief

Antimail Script recipe of the week how to copy an opened file | Menopause Relief — Tue, 09 Jun 2009 03:06:18 GMT

PingBack from http://menopausereliefsite.info/story.php?id=1213

Antimail Script recipe of the week how to copy an opened file | Cast Iron Cookware

Fri, 12 Jun 2009 05:48:12 GMT

PingBack from http://castironbakeware.info/story.php?title=antimail-script-recipe-of-the-week-how-to-copy-an-opened-file

Antimail Script recipe of the week how to copy an opened file | fix my credit

Antimail Script recipe of the week how to copy an opened file | fix my credit — Wed, 17 Jun 2009 04:56:29 GMT

PingBack from http://fixmycrediteasily.info/story.php?id=4498