| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-07-28 : 17:13:20
|
MOO indeed...So why does this stop after the copy...this in a bat fileosql -i D:\backup\paerscbvd0402\dev\databases\blddistm\sql\BackupCopyRestore.sql -o D:\backup\paerscbvd0402\dev\databases\blddistm\bin\Migrate_paerscbvd0402_dev_blddistm.log -E -S PAERSCBVD0402\DEV osql -i D:\backup\paerscbvd0402\dev\databases\blddistm\sql\MakeBKP.sql -o D:\backup\paerscbvd0402\dev\databases\blddistm\bin\MakeBKP.log -E -S PAERSCBVD0402\DEV D:\backup\paerscbvd0402\dev\databases\blddistm\bin\CopyBKP.bat > D:\backup\paerscbvd0402\dev\databases\blddistm\bin\CopyBKP.logosql -i D:\backup\paerscbvd0402\dev\databases\blddistm\sql\AlterDB.sql -o D:\backup\paerscbvd0402\dev\databases\blddistm\bin\AlterDB.log -E -S PAERSCBVD0403\DEV osql -i D:\backup\paerscbvd0402\dev\databases\blddistm\sql\RestoreBKP.sql -o D:\backup\paerscbvd0402\dev\databases\blddistm\bin\RestoreBKP.log -E -S PAERSCBVD0403\DEV osql -i D:\backup\paerscbvd0402\dev\databases\blddistm\sql\SetDB.sql -o D:\backup\paerscbvd0402\dev\databases\blddistm\bin\SetDB.log -E -S PAERSCBVD0403\DEV Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-07-28 : 17:14:39
|
I think you got that backwardsCOPY [/D] [/V] [/N] [/Y | /-Y] [/Z] [/A | /B ] source [/A | /B] [+ source [/A | /B] [+ ...]] [destination [/A | /B]] source Specifies the file or files to be copied. /A Indicates an ASCII text file. /B Indicates a binary file. /D Allow the destination file to be created decrypted destination Specifies the directory and/or filename for the new file(s). /V Verifies that new files are written correctly. /N Uses short filename, if available, when copying a file with a non-8dot3 name. /Y Suppresses prompting to confirm you want to overwrite an existing destination file. /-Y Causes prompting to confirm you want to overwrite an existing destination file. /Z Copies networked files in restartable mode. Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-29 : 02:26:03
|
| "So why does this stop after the copy"osql ...osql ...CopyBKP.batosql ...osql ...osql ...The BAT file will NOT return. You have to do EXEC CopyBKP.bator somesuch (CMD CopyBKP.bat perhaps?) if you want it to return. And it may have to do its own ">" logging as the outer ">" may not apply. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-07-29 : 07:04:27
|
| call CopyBKP.bat |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-30 : 06:17:22
|
| That's it! Thanks Rob. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
DOS -Q
Brett8-)Hint: Want your questions answered fast? Follow the direction in this link