Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
database backup
Name: suneela Date: February 25, 2009 at 03:14:59 Pacific OS: Windows XP Subcategory: General
Comment:
i have written a batch file to backup database batch file is working if the data is not being used its not working when the data is online or data is being used by other software how can i make batch file run
Name: Jennifer SUMN Date: February 25, 2009 at 12:36:32 Pacific
Reply:
If the database is open, it can't be accessed for backup.
You could set the batch file to run at a time when the database isn't being used...like in the middle of the night.
"So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown
0
Response Number 2
Name: suneela Date: February 25, 2009 at 21:17:00 Pacific
Reply:
ok thanks what is this poem i don't understand
0
Response Number 3
Name: Jennifer SUMN Date: February 26, 2009 at 07:14:15 Pacific
Reply:
It's not a poem. It's a lyric from a Shinedown song.
EEOC
0
Response Number 4
Name: Jennifer SUMN Date: March 4, 2009 at 09:38:34 Pacific
Reply:
Recovery software is not the same thing as backup software.
EEOC
0
Response Number 5
Name: suneela Date: March 4, 2009 at 21:00:13 Pacific
Reply:
sir i did this by temporarily disconnecting the sql server by sc.exe and after backing up started sql server. the backup batch file is running well, but i think it is corrupting the database. what would be the reason
Summary: This might also help: Before you begin, make sure the table is not in use. Then use the isql utility to perform these manual steps, entering go after each command: 1. Turn on support for maki...
Summary: I want to attach a database to SQL 2005, but i am restricted as to where the database backup file can be in. I would like it to be in my documents/.......but for some reason I cannot search there.......
0 
help! blank lines (break,...
