Viewing 15 posts - 15,076 through 15,090 (of 39,970 total)
I think that Dev has a good list. The thing I might do as well is take the script you have for jobs/logins/etc and stick it in an admin table...
October 19, 2011 at 10:21 am
Doh! spellcheckers and proofreaders fail me.
My typo has been corrected.
October 19, 2011 at 10:18 am
We're sitting here, and I'm supposed to be the editor,
and we're talking about (bleep)ing pants.
I mean listen, we're sitting here talking about (bleep) pants,
not SQL Server, not Integration Services,...
October 18, 2011 at 5:32 pm
Revenant (10/18/2011)
Steve Jones - SSC Editor (10/18/2011)
Revenant (10/17/2011)
It has nothing to do with engineers in the Servers and Tools Division and in support (ECO).
Sorry.
Not sure I implied it did. It's...
October 18, 2011 at 10:56 am
Post code, but probably try..catch for each one because they're separate batches.
Alternative is do something like Powershell to make the changes instead with error handling in there.
October 18, 2011 at 8:32 am
Or upgrade to R2 on the server you are restoring to
October 18, 2011 at 8:31 am
Ninja's_RGR'us (10/18/2011)
Take 30 minutes and read those 2 articles.You'll understand exactly what's going on and how to fix it.
http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Second vote for this.
Manage your log files, do not truncate them.
October 18, 2011 at 8:28 am
Sean Lange (10/18/2011)
I pretty much started it and you are right. It was unprofessional. I have removed my comment and apologized to the poster.
It wasn't aimed specifically at you, but...
October 18, 2011 at 8:24 am
Congrats again, Jeff, and a nice ceremony for you and a nice speech from you. The award was well deserved.
October 18, 2011 at 8:15 am
Just an FYI, since many of you post often, this thread is a little inappropriate in terms of responses to the poster. I know he's a troll, or lazy, or...
October 18, 2011 at 8:07 am
For the original poster: Please use a search engine or Books Online to research these questions. We are happy to help you with specifics, but without any effort on your...
October 18, 2011 at 8:03 am
Ease is relative. A backup restore requires double the disk space of the data (backup file + database mdf/ldf). An attach requires the space only for the mdf/ldf.
The physical name...
October 18, 2011 at 8:00 am
FYI, not sure if you saw it, or can see it, but Dr. Dewitt's talk on Big Data and Hadoop is great: http://www.sqlpass.org/summit/2011/Live/LiveStreaming/LiveStreamingFriday.aspx
October 18, 2011 at 7:55 am
WayneS (10/17/2011)
Anyone have an idea if this post http://www.sqlservercentral.com/Forums/FindPost1191243.aspx is spam? (Afraid to click the link that is in that linked post...)
It's OK. Not sure about the quality, but it's...
October 18, 2011 at 7:53 am
mannaggia (10/18/2011)
October 18, 2011 at 7:51 am
Viewing 15 posts - 15,076 through 15,090 (of 39,970 total)