Forum Replies Created

Viewing 15 posts - 8,521 through 8,535 (of 9,248 total)

  • RE: Full backup and rebuild index jobs are failing

    RPSql (1/12/2009)


    Hi Everyone,

    I have one issue..I have server A and Server B. Now on Server B my sql server agent is disabled. I have setup a maintenance...

  • RE: Database size is increasing rapidly

    check your column data types, growing 8GB in 3 years doesnt seem too wrong depending on the data you are storing

  • RE: Shrinking MSDB database in SQL Server 2005

    piece of advice, dont screw with MSDB if you must backup the database first.

    apart from that, 335 MB isnt too bad but i noticed the job history table is...

  • RE: Systems DB Move

    Tracey

    remember the path for the resource db data and log file must be the same as the master.mdf

  • RE: SQL 2005 and GIS server

    SQL_Quest

    what version of ArcGIS are you using?

    The spatial layers are part of the ArcSDE engine. You can use direct connect to connect to the database from the SDE engine...

  • RE: Need Uninstall Option for Service Packs

    most updates affect the system databases, i dont think an un install would not be a viable option, although nice too have. An un install would have to tie in...

  • RE: SQL Server, SANs and Virtualisation

    colin Leversuch-Roberts (1/12/2009)


    see what a hornets nest this stirs up.

    you're not wrong there sir. A great thread going on here!

    who will win the speed war copper or fibre...

  • RE: SQL Server, SANs and Virtualisation

    its worth noting if you licence the cpus for Enterprise edition of SQL server at the host level, it will cover you for unlimited sql server cpu licences on any...

  • RE: Best method to migrate to new DB server

    unless your using Redgate or Litespeed, you have have to backup the database which can take a while depending on the size. You then have to copy that file across...

  • RE: Best method to migrate to new DB server

    i would detach then re attach. Backup and restore remember that if you backup the database and restore, if any transactions get made against the old database then you'll need...

  • RE: SQL Server, SANs and Virtualisation

    homebrew01 (1/10/2009)


    Perry Whittle (1/10/2009)


    homebrew01 (1/10/2009)


    Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have the VM...

  • RE: SQL Server, SANs and Virtualisation

    homebrew01 (1/10/2009)


    Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have the VM overhead, but not...

  • RE: RAID 1 vs. RAID 10

    colin Leversuch-Roberts (1/9/2009)


    On one san I have aligned partitions with 64kb block size, 128kb stripe, raid 10 dedicated spindles; I also have some 4kb block size non aligned partitions also...

  • RE: Create database using Backup file

    click in the combo box and type a new database name 😉

    if you right click at the "databases" node of the tree view the combo box should be empty when...

  • RE: SQL Server, SANs and Virtualisation

    SQLBOT (1/8/2009)


    Virtualization creates a safe sandbox environment for sa, but does add the overhead of providing a memory and disk space for the OS.

    the only caveat here is unless the...

Viewing 15 posts - 8,521 through 8,535 (of 9,248 total)