Viewing 15 posts - 6,526 through 6,540 (of 9,253 total)
nevhirion (9/27/2011)
Yes, I saved the executable to C:\ and ran it from there.
Ok, but that's not what I suggested you do. I suggested you unpack the SP using the /X:...
September 28, 2011 at 1:13 am
adding the role to the server shouldnt require a reboot
September 27, 2011 at 5:16 pm
Windows 2008 or Windows 2003?
September 27, 2011 at 4:57 pm
Green Armchair (9/27/2011)
I can't be rebooting nodes that are currently running production instances.Thanks
Andy
uninstall from a passive node and the reboot wont matter
September 27, 2011 at 4:14 pm
Sqlsavy (9/27/2011)
on WIndows 2003,SP2 has only 4GB RAM .
Enterprise or Standard?
32 bit or 64 bit?
Sqlsavy (9/27/2011)
I've enabled AWE
Did you enable the Lock Pages in Memory local security policy for the...
September 27, 2011 at 2:30 pm
p.van.der.zande (9/26/2011)
"Upgrade fro mSQL Server 2000/2005/2008" It says there is nothing to upgrade (the instance is already at 2008 R2 level).
That is not how you change your SQL Server 2008...
September 27, 2011 at 11:23 am
george sibbald (9/27/2011)
try taking a log backup of the primary, then apply that to the mirror with norecovery. Then try to initiate mirroring.
also any log backups that have been carried...
September 27, 2011 at 6:39 am
i dont know much about your setup, is it likely the log will fill up in 15 mins?
If you know the mirror would be down for an excessive period of...
September 27, 2011 at 5:28 am
database and backup sizes?
disk layouts?
file layouts?
September 27, 2011 at 4:56 am
personally i would ensure the 2 are synchronised and then pause the session, reboot the mirror and then resume the session
September 27, 2011 at 4:36 am
what's wrong with using these?
exec sp_helpserver
exec sp_helplinkedsrvlogin
September 27, 2011 at 4:31 am
to be able to map a user to a sql server database you need DB_AccessAdmin role in that specific database. DB_SecurityAdmin is for managing permissions and role memberships
September 27, 2011 at 4:02 am
Just because you verified the file doesn't mean something can't happen to the file on disk 😉
September 26, 2011 at 4:50 pm
You need to understand log shipping a little better.
At the moment you are restoring the last full backup and all logs for the previous day in one go. You...
September 26, 2011 at 4:47 pm
backup to disk instead of sloooooooooooowwww tape
September 26, 2011 at 2:57 pm
Viewing 15 posts - 6,526 through 6,540 (of 9,253 total)