Viewing 15 posts - 1,246 through 1,260 (of 1,319 total)
Something has changed if it ran for years without issue. My guess is your source file. The error is pretty self-explanatory as it states your column delimiter is missing (what...
-- You can't be late until you show up.
March 26, 2008 at 7:45 am
Donn, the beauty of a maintenance plan is that you can select all non-system databases. This will grab any database, new or not, and add them to the backup job....
-- You can't be late until you show up.
March 24, 2008 at 7:31 am
Actually, while I agree with your comments, especially about knowing what is causing the growth and the expense of growing (and shrinking), the tasks can be performed as simply as..
BACKUP...
-- You can't be late until you show up.
March 21, 2008 at 11:27 am
This is straight from BOL. I apologize if it looks basic but it should be a very simple task. The assumption with this script is that you have one data...
-- You can't be late until you show up.
March 21, 2008 at 9:00 am
This is how I do it. See if this works (it's pretty staright forward). In EM, right-click and create database. On the new database, right-click->All Tasks->Restore. On the restore pane,...
-- You can't be late until you show up.
March 21, 2008 at 8:13 am
Seems to be a VERY popular subject lately! Check this other thread going on. It should help. Re-read Steve's comments in the first link after you've accomplished what you want...
-- You can't be late until you show up.
March 21, 2008 at 7:45 am
This works for me. I'm running SQL 2K, sp4. Perhaps the missing GO statement at the bottom?? And notice that I've commented out the were clause. If it wraps on...
-- You can't be late until you show up.
March 20, 2008 at 7:29 am
This is kind of primitive but it works. It'll retrieve all non-system databases on a server (DB_ID> 4). The where clause seems to fit you condition of only non-autogrow databases...
-- You can't be late until you show up.
March 19, 2008 at 2:53 pm
Post the script and we'll absolutely help.
-- You can't be late until you show up.
March 19, 2008 at 9:58 am
Under the maintenance plan, "Remove Files older than", set whatever works for you (1 day, 1 week, etc.). A maintenance plan should be creating a separate file with a date/time...
-- You can't be late until you show up.
March 19, 2008 at 9:03 am
I agree with John, use the resources, learn a little and if you have specific issues, post them. Many of us will gladly help...but try and help yourself first. Having...
-- You can't be late until you show up.
March 19, 2008 at 8:36 am
So on a restart, you didn't see a continuation of the rollback prior to the database being brought on line? That would be very odd, possible I guess, but strange....
-- You can't be late until you show up.
March 18, 2008 at 8:59 am
Check out this link:
http://msdn2.microsoft.com/en-us/library/ms130214.aspx
-- You can't be late until you show up.
March 18, 2008 at 8:14 am
I personally like to have all my maintenance done prior to my backups. If I come in the next day and we have any issue, if I restore to my...
-- You can't be late until you show up.
March 18, 2008 at 8:10 am
See SQL ORACLE's comment about stopping MSSQL and rollback occurring. It's still going to happen. You're simply delaying the process.
-- You can't be late until you show up.
March 18, 2008 at 8:03 am
Viewing 15 posts - 1,246 through 1,260 (of 1,319 total)