Viewing 15 posts - 1,411 through 1,425 (of 4,745 total)
Dave Mason (11/4/2011)
Markus (11/3/2011)
A SQL2005 version of master and MSDB won't work in a SQL2008 install via the backup/restore method.
Agreed! That is why I posed the following...
---------------------------------------------------------------------
November 4, 2011 at 8:37 am
what do you mean by replicate?
literally replication or just some form of copying the database to another server (so logship, full db restores, anything?)
---------------------------------------------------------------------
November 3, 2011 at 10:34 am
Dave Mason (11/2/2011)
Elliott Whitlow (11/2/2011)
You are asking for trouble...CEWII
Why? Can you give me some specifics?
maintenance plans will still point to the old server - and try to run against...
---------------------------------------------------------------------
November 3, 2011 at 9:02 am
in administrative tools\failover cluster manger right click on the SQL resource under services and applications and offline the service.
Same process to bring it back up but 'online' the service
---------------------------------------------------------------------
November 3, 2011 at 8:52 am
x86 equates to 32 bit.
---------------------------------------------------------------------
November 3, 2011 at 8:48 am
try refreshing the SSMs display (right click on database and select 'refresh'
---------------------------------------------------------------------
November 2, 2011 at 5:41 am
MaxDD (11/1/2011)
And not to worry about VMWare causing the OS to read 8GB of ram
not sure I understand what you mean by that?
---------------------------------------------------------------------
November 1, 2011 at 2:59 pm
..and thank you for the feedback.
---------------------------------------------------------------------
November 1, 2011 at 2:54 pm
with 32 bit you MUST enable lock pages in memory to use AWE. You will need to restart SQL.
---------------------------------------------------------------------
November 1, 2011 at 2:15 pm
use the alter database command (see BOL).
If you are renaming the PHYSICAL file name you will need to
offline database (also an alter database command)
run alter database command modify file command
rename...
---------------------------------------------------------------------
November 1, 2011 at 2:09 pm
You dont HAVE to delete these directories in order to be able to reinstall its just neater and you may have files under those directories you dont want anymore (e.g....
---------------------------------------------------------------------
November 1, 2011 at 9:54 am
add\remove programs should cleanly uninstall all the components of SQL (make sure you select all the components) and the SP allowing you to reinstall.
there will be some directories left behind...
---------------------------------------------------------------------
October 31, 2011 at 4:45 pm
If they are not already in that state switch the log shipping restores to norecovery and restore up to the very latest log so the database is in in recovery...
---------------------------------------------------------------------
October 31, 2011 at 4:29 pm
willian.funes (10/28/2011)
thats my first time and I was...
---------------------------------------------------------------------
October 28, 2011 at 9:50 am
george sibbald (10/26/2011)
read to me (as if you never want to truncate the log).
Nooo idea why that ended up in brackets :ermm:
---------------------------------------------------------------------
October 26, 2011 at 4:09 pm
Viewing 15 posts - 1,411 through 1,425 (of 4,745 total)