Viewing 15 posts - 871 through 885 (of 2,897 total)
It's been running 2 hours and I get 0 🙁
July 26, 2011 at 11:48 am
It's always good to have multiple options to accomplish a task, but in this case there are several detriments to the proposed method, with no obvious advantages. If you...
July 25, 2011 at 12:13 pm
halifaxdal (7/25/2011)
I plan to do my backup this way:
1. stop server
2. copy all mdf/ldf to another place
3. restart server
Is it the best and safest way to run a reliable...
July 25, 2011 at 9:55 am
GilaMonster (7/21/2011)
halifaxdal (7/21/2011)
Error 5173: Cannot associate files with different databases.
Could not restart database 'CheckListDB', reverting back to old status.
ALTER DATABASE statement failed.
Log file 'D:\Program Files\Microsoft SQL...
July 21, 2011 at 2:11 pm
Ninja's_RGR'us (7/20/2011)
bernard black (7/20/2011)
Find out what bars you've been at on Sat night. Get someone to monitor your behavior when you leave the bar.
I don't get it, care to...
July 20, 2011 at 9:38 am
detach-attach will be quicker than backup & restore.
July 20, 2011 at 9:09 am
"..... take time to do all the work for just doing a SP upgrade ...."
What work ? Service Packs are pretty straightforward. I would be hesitant if it...
July 20, 2011 at 8:51 am
Ninja's_RGR'us (7/20/2011)
homebrew01 (7/19/2011)
Ninja's_RGR'us (7/19/2011)
homebrew01 (7/19/2011)
July 20, 2011 at 8:29 am
Going to Service Pack 3 should fix the problems. You should be on SP3 (or SP4) anyway. SP2 is very old.
July 19, 2011 at 7:03 pm
mtillman-921105 (7/19/2011)
GilaMonster (7/19/2011)
What whitespace where? Can't see anything odd.I think he's talking about extra lines in the code block rather than to the right of the code.
Yes ... maybe specific...
July 19, 2011 at 7:01 pm
Is the 116 G all .mdf file, or do you have an .ldf growing big because there's no regular t-log backup ?
July 19, 2011 at 6:54 pm
Shrink Database fragments the database and hurts performance. Generally a bad idea, unless you are so low on disk space that you are about to crash the server.
There are many...
July 19, 2011 at 12:45 pm
Ninja's_RGR'us (7/19/2011)
Are you doing this with sa permissions?This screams only 3 things to me :
#1 Bad install of the gui
#2 Missing permissions
#3 Missing patch.
Could be #3. Many problems with...
July 19, 2011 at 12:38 pm
Ninja's_RGR'us (7/19/2011)
homebrew01 (7/19/2011)
July 19, 2011 at 12:32 pm
In addition, I run a job to script out objects to a folder every week as another layer of protection. If I need to recover stored procedure code, it's simpler...
July 19, 2011 at 11:00 am
Viewing 15 posts - 871 through 885 (of 2,897 total)