Viewing 6 posts - 1 through 6 (of 6 total)
Another sugestion is to do a backup scheme for sysobjects with a bcp for example, quick and easy.
Just remember that some sp's are split in several rows.
Regards.
December 14, 2005 at 6:06 pm
This is what I will do, very basic testing:
(all from xp_cmdshell)
-Check if you can "dir" the directory
-Creating a file like "dir > path/test.txt"
-do a bcpout and then bcp in
Very basic...
December 14, 2005 at 6:01 pm
When you change the account in EM it suppose to do all necesary things to get the account to work with the service but make shure all the properties are...
December 8, 2005 at 9:33 am
The thing about this is that the corrupted database is not on master..sysdatabases anymore, it had been deattached.
Regards
December 1, 2005 at 5:54 pm
After checking all those good network suggestions above try doing it without DTS and VBScript, (backup query, xp_cmdshell for zipping) it had worked fine for me for years (if you...
December 1, 2005 at 9:34 am
I had this similar problem, I crash a DB trying to restore a backup to it but got stuck in the middle of the process, I try the same detach...
December 1, 2005 at 9:20 am
Viewing 6 posts - 1 through 6 (of 6 total)