Forum Replies Created

Viewing 15 posts - 691 through 705 (of 966 total)

  • RE: SQL Server Service not starting

    Is the syntax of the command to reinstall master correct? I ask because you listed

    "start /wait D:\setup.exe /qn INSTANCENAME=mssqm$ICT REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword"

    supplying an instance name of mssqm$ICT yet your error...

    Joie Andrew
    "Since 1982"

  • RE: Need help immediately= Installing seperate instance on server

    If the service account that SSIS uses on the machine does not have a login on the named instance or NTFS file permissions to the data/log files of the named...

    Joie Andrew
    "Since 1982"

  • RE: @job_login must have a valid Windows login...(Snapshot replication error)

    What value are you supplying for @job_login? Is it a valid/active account on the machine/domain the systems are a part of?

    Joie Andrew
    "Since 1982"

  • RE: SQL Server 2000 Replication Performance

    Yeah, then either log shipping or transactional replication. You can setup transactional replication not to have immediate updates to reduce some of the load on the box. If you have...

    Joie Andrew
    "Since 1982"

  • RE: Tlog restore

    Sorry. Steve is absolutely correct. I was making an assumption about the full backup restore being done. The logs have to be restored in order, so it will be full,...

    Joie Andrew
    "Since 1982"

  • RE: Replication issues

    Also, if it is cross domains you may hit permissions problems even if the everyone group is added if domain trusts are not setup correctly. I would ensure with your...

    Joie Andrew
    "Since 1982"

  • RE: Full Backups - Snapshot - Tlogs- Chain is broke ..Please help!!

    You are going to have to get with your storage administrator to work and understand this, as each SAN vendor can implement snapshots in different ways. For example we use...

    Joie Andrew
    "Since 1982"

  • RE: connect to remote sql server without using SMO/ADO?

    You can also try a roundabout way. If the purpose is to not use ADO/SMO yet use the power of powershell you could try something like using sqlcmd inside of...

    Joie Andrew
    "Since 1982"

  • RE: Tlog restore

    Restore from transaction log backups. They should contain all the transactional changes since the last full backup.

    Joie Andrew
    "Since 1982"

  • RE: MSDE in Personal , Entireprise Sql

    Once you install MSDE, there is no upgrading it to another version like Standard, Enterprise, etc. You can install Enterprise as another instance of SQL on the same machine, but...

    Joie Andrew
    "Since 1982"

  • RE: SQL Server 2000 Replication Performance

    Are any of the queries these users will run going to be expected to modify the data in anyway?

    Joie Andrew
    "Since 1982"

  • RE: SQL Server on a virtual server

    If you are moving machines make sure to also plan out carefully where the database files will be. Separation between the OS, data and log files as well as tempdb...

    Joie Andrew
    "Since 1982"

  • RE: SQL Server on a virtual server

    Well I would definitely say that your indexes should be rebuilt if any of them have large fragmentation. Does the server have any maintenance periods, non-business hours or known periods...

    Joie Andrew
    "Since 1982"

  • RE: SQL Server on a virtual server

    How many VMs are running along with the SQL VM on the same physical box, and what kind of servers are they?

    Joie Andrew
    "Since 1982"

  • RE: Log Shipping DB2 to SQL Server2000/2005/2008

    The only option left is then to pull the complete data from the production server on a daily basis, which is logically incorrect.

    That's not your only option left. Have you...

    Joie Andrew
    "Since 1982"

Viewing 15 posts - 691 through 705 (of 966 total)