Viewing 15 posts - 556 through 570 (of 691 total)
When one fails, how did the one previous to it do? Did it run longer than 15 minutes? What else is going on when one times out?
June 16, 2004 at 12:24 pm
I'm not completely sure what you are trying to achieve or what you are experiencing. I suspect that you are attempting to number the records in a sequential order as...
June 15, 2004 at 3:12 pm
I wonder if a tool like Lumigent Log Explorer would work? I don't know if it works on a log file that is not attached to a db.
Steve
June 15, 2004 at 2:25 pm
I haven't seen many issues managing 7.0 with 2000 tools, but there are a few!
Hope the sp_resetstatus works for you.
Steve
June 15, 2004 at 2:01 pm
Not sure that you can restore from a network share. Check Books online for the RESTORE syntax and try it from the query tool. If all else fails, copy the...
June 15, 2004 at 1:52 pm
Did you do this from a SQL 2000 Enterprise Manager? I have experienced this with "offline", which is not supported in 7.0.
You might try using sp_resetstatus to reset the...
June 15, 2004 at 1:45 pm
You will need to re-install SQL Server on your DR box, then restore the backups.
You will also have to repair permissions, as all of your db users will be...
June 15, 2004 at 1:38 pm
When you test in query analyzer, are you using the same loginid that the app uses?
June 15, 2004 at 1:30 pm
You could write a stored proc to read the agent log into a table, and check the time stamp. If a new error is found, send e-mail, page, alert of your choice.
Steve
June 15, 2004 at 1:15 pm
Script the job (right click, all tasks, generate sql script), then pull the code out that creates the schedule. Insert that code into your job. Use sp_add_jobschedule to add a...
June 15, 2004 at 1:08 pm
Are you upgrading the software or just moving the databases?
If upgrading the software, make sure that you have good backups of the databases, install 2000, and run the upgrade wizard.
If...
June 15, 2004 at 12:38 pm
Several years ago in a disaster recovery test, we experienced problems restoring a database that had been backed up by Veritas. It, too, was in the 30 gb range. We've never...
June 15, 2004 at 12:33 pm
Based on what you said, I don't think you have a problem. The log should automatically grow by 5mb if necessary. BUT, you can eliminate the "percent log used" message...
June 15, 2004 at 12:20 pm
You could write a sql script to check that the size of the file is greater than 0, if not, don't execute the dts. The script would need to create a...
June 11, 2004 at 3:48 pm
If you change the job to run as "SA", the user wouldn't require sa level authority.
June 11, 2004 at 3:41 pm
Viewing 15 posts - 556 through 570 (of 691 total)