Viewing 15 posts - 31 through 45 (of 48 total)
script out the role in QA and change the existing rolename with the new name,
run the script,
verify if everything is in order
HTH
February 13, 2006 at 6:14 pm
as part of the security measures that a DBA needs to take is to remove the builtin/administrator account
in installing the service pack, you need to provide the logon account with SA...
February 12, 2006 at 11:24 pm
1. CREATE command wrong
2. check for available disk space on the drives mentioned
3. are you creating the database remotely? like over a SAN?
4. the path is a default one, ask...
February 12, 2006 at 8:48 pm
There is a workaround but it requires you to create an exe for them. Make use of approle (with appropriate privileges) and query through sysprocesses to filter out the processes...
February 12, 2006 at 7:30 pm
You should plan for this type of disaster, I've implemented something simple but serves its purpose
1. change recovery model of the database to full
2. create jobs that will do a...
February 12, 2006 at 7:22 pm
In a nutshell,
treat an instance like a separate sql server system, in one box, you can have more than 1 instance depending on the version you have
you can actually have...
February 10, 2006 at 12:14 am
Hi Ken,
I'm interested on the formula you used (wanted to learn how)
why did you use the factor 8 to get total GB and 1.2 to get raw bandwidth rate?
thanks in...
February 9, 2006 at 10:40 pm
yep, check for sysjobs union with sysjobhistory for run_status
concurrently check sysprocesses so that you'll have a baseline when to stop trying
but as i mentioned, an error for failed distribution agent...
February 9, 2006 at 8:30 pm
maximum is 9999
replication contributes to a part of your server performance, so if you keep asking the server to retry the connection for n-minutes and infinitely, you might have some...
February 9, 2006 at 5:47 pm
if you have no log files to work with, you could probably charge this to experience, otherwise verify if you have full recovery set for the database and then you...
February 9, 2006 at 12:54 am
here's a checklist:
sqlserveragent running on a domain account with local admin privilege
outlook client installed on server
mapi profile created for the service account
opened outlook client while service account logged on, atleast...
February 9, 2006 at 12:24 am
you might not be able to connect
you can explore named instances, failover clustering, logshipping instead
the change will happen on the apps level via an ini file most probably
HTH
February 9, 2006 at 12:01 am
anything is possible
but it is always better to test on a test server prior to implementation, different environments may result differently (especially when it involves network restrictions)
HTH
February 8, 2006 at 11:00 pm
IMHO, this will not be an efficient setup for you, if the distribution agent fails then something must be really wrong (reasons for network failure are diverse) and should remain...
February 8, 2006 at 10:53 pm
if you have a server + backup setup and up to doing the log shipping yourself, this will be the better approach compared to replication (since you do not need...
February 8, 2006 at 10:48 pm
Viewing 15 posts - 31 through 45 (of 48 total)