Forum Replies Created

Viewing 15 posts - 31 through 45 (of 48 total)

  • RE: Rename A Role

    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

  • RE: Question about removing Builtin administrator account

    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...

  • RE: Fail to Create New Database

    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...

  • RE: KILL a process

    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...

  • RE: How to Restore POS System to SqlServer 2000

    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...

  • RE: SQL Server Instance

    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...

  • RE: Log shipping - file transfer

    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...

  • RE: distribution agent

    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...

  • RE: distribution agent

    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...

  • RE: Recovering overwritten data

    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...

  • RE: SQL server Agent

    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...

  • RE: SQL Server Name differnt to Computer Name

    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

  • RE: Restoring Distribution Database

    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

  • RE: distribution agent

    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...

  • RE: Replication with a Log Shipping Backup

    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...

Viewing 15 posts - 31 through 45 (of 48 total)