Viewing 15 posts - 1,276 through 1,290 (of 4,745 total)
logicinside22 (12/27/2011)
thanks folks for nice reply . I did with Detach and Attach Option and it looks good now.
can I then recommend that you check logins still have the correct...
December 27, 2011 at 2:37 pm
backup\restore with move is another possibility but alter database is the best way to do this.
If at all possible backup the database first, just in case.
December 27, 2011 at 1:58 pm
this is a 'feature' (bug) of the install gui. Either accept the defaults (no harm in doing that) or install from the command line specifying the values you want for...
December 26, 2011 at 9:38 am
A christmas present for you............
http://www.sqlservercentral.com/articles/Administration/64582/
December 25, 2011 at 11:34 am
You need to be able to get inside Steves mind for these questions!
Remember, 7 points should not be too easy to get, and steve has an wicked streak! 🙂
Happy christmas!
December 25, 2011 at 11:24 am
was torn between reindeer and turkey, but knowing that americans eat turkey at thanksgiving guessed right.
so what do americans traditionanlly eat at christmas?
December 23, 2011 at 12:40 pm
You can take the bits that you need out of here
December 16, 2011 at 4:16 pm
reggie burns-317942 (12/16/2011)
Can you explain alittle further about the suggested process? Thanks.
pls starrt a new thread so we don't hijack this one
December 16, 2011 at 1:08 pm
I wouldn't say its a common practice, but the logical name is not really that important except perhaps for clarity within sys.master_files and making restores more straight forward.
I would guess...
December 16, 2011 at 12:37 pm
reggie burns-317942 (12/16/2011)
I'm having the same issue, but I'm experiencing the issue with these dbs having the same logical name. I'm attempting to configure log shipping for over 100...
December 16, 2011 at 12:30 pm
Its a change at the SQL level, which is a 'virtual' instance sitting on both nodes, so yes it will be in effect whichever node is the active node
edit: by...
December 16, 2011 at 10:07 am
as john said. Offline just stops the resource (and dependant resources).
Failing over is a different option (move resource).
Failing over would also cause a restart of SQL and start up the...
December 16, 2011 at 9:53 am
it will not force a restart.
with a cluster you have to use the failover cluster manager to restart SQL.
Right click on the SQL server resource and choose 'offline the resource'....
December 16, 2011 at 8:18 am
Viewing 15 posts - 1,276 through 1,290 (of 4,745 total)