Viewing 15 posts - 1,621 through 1,635 (of 7,498 total)
You don't need to take your instance nor db offline to create valid sqlserver backups.
Have a look at "backup database" in books online.
Keep in mind you also need "backup log"...
October 24, 2011 at 9:57 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
Options were cholera or plague. What did...
October 24, 2011 at 12:22 am
M_E_K (10/20/2011)
October 20, 2011 at 11:55 pm
I would NOT take a troublesome db offline !!!! ( unless pss tells me to )
I must have overread it, but anyway here's my primitive Q:
- Does your service account...
October 20, 2011 at 7:44 am
So, that's what do you get when suffering a SQLServer overdose at SQLpass ... Pantoriosis
😀
G'night y'all
October 18, 2011 at 3:41 pm
My second place to check would also be io/ram related.
Any hints in the windows evenlog files ?
Are there other startup processes on these boxes ? (that have the need for...
October 18, 2011 at 8:28 am
Roy Ernest (10/17/2011)
Jack Corbett (10/17/2011)
SQLRNNR (10/17/2011)
Evil Kraig F (10/17/2011)
October 18, 2011 at 12:59 am
best is to set a different value for min and max server memory.
SQLserver can have issues when these values are equal.
If this is a dedicated box, why would you enforce...
October 17, 2011 at 1:32 pm
Roy Ernest (10/17/2011)
October 17, 2011 at 8:22 am
Perry Whittle (10/17/2011)
ALZDBA (10/17/2011)
Perry Whittle (10/11/2011)
Dev @ +91 973 913 6683 (10/11/2011)
I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well.
Oracle...
October 17, 2011 at 6:55 am
Perry Whittle (10/11/2011)
Dev @ +91 973 913 6683 (10/11/2011)
I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well.Oracle uses it too
Since...
October 17, 2011 at 3:19 am
how about using the good old bcp way of doing things ?
October 10, 2011 at 8:48 pm
Well, for this being a new instance, you should apply SP4 !
No doubt about that, since you have to test it all.
Collation could indeed be an issue if you have...
October 10, 2011 at 8:46 pm
btw get used on using the statement terminator ';' because it will become mandatory in one of the next versions !
That will save you time fixing it later on 😉
October 10, 2011 at 1:46 pm
Jeff Moden (10/9/2011)
ALZDBA (10/9/2011)
SSC has some nice articles to get you started with both.
For...
October 9, 2011 at 6:48 pm
Viewing 15 posts - 1,621 through 1,635 (of 7,498 total)