Forum Replies Created

Viewing 15 posts - 181 through 195 (of 492 total)

  • RE: backup- Create a sub-directory for each database

    No, it doesn't delete the old folder. It just creates it if it doesn't exist.

    But you can always do a test backup, then a second backup and see what happens.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    September 6, 2011 at 4:17 pm

    #1377730

  • RE: SQL 2005 SP3 Installed - Still shows SP2

    Ignacio A. Salom Rangel (9/1/2011)

    How many SQL Server instances you have on the cluster?

    It's a single instance, Active/Passive cluster

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    September 1, 2011 at 4:41 pm

    #1376222

  • RE: SQL 2005 SP3 Installed - Still shows SP2

    SQLRNNR (9/1/2011)

    Looks like just the tools upgraded and not the database engine.

    More likely the other way around since sqlservr.exe version shows 4035.

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    September 1, 2011 at 3:48 pm

    #1376210

  • RE: report manager print button not work

    Was this working an now suddenly not working? And on only some work stations?

    I know there were issues with WinXP after some service packs that disabled the AxtiveX control in...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 29, 2011 at 7:18 pm

    #1374786

  • RE: Physical CPU or Logical Processors ?

    Jeffrey Williams-493691 (8/20/2011)

    To the previous posters about SQL Server Standard only using 4 CPU's - I believe that is a licensing number and does not have any relationship to the...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 21, 2011 at 2:38 pm

    #1371200

  • RE: Physical CPU or Logical Processors ?

    GilaMonster (8/18/2011)

    but Standard Edition will never use more than 4 cores in total.

    Can you point me to a document on this? I'm not convinced that standard can only...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 18, 2011 at 1:30 pm

    #1370346

  • RE: Physical CPU or Logical Processors ?

    SQLRNNR (8/17/2011)

    You have 2 sockets and 8 processors.

    Except if you licence Per Processor, you only pay for 2 licences, not 8.

    This took me for ever to get my head around.

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 17, 2011 at 2:03 pm

    #1369835

  • RE: Physical CPU or Logical Processors ?

    If you look at how many processors SQL sees, you will see it says 8. If you want to set MAXDOP to try elliminate the CXPacket waits then 1 is...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 17, 2011 at 2:01 pm

    #1369831

  • RE: Migration jobs from sql server 2000 to 2005

    Did you review the scripts before you ran them? Did they look correct?

    Also after you ran the scripts where there any errors reported.

    There are a few things that can go...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 17, 2011 at 1:54 pm

    #1369827

  • RE: Log shipping deleting log files too soon.

    jprovines (8/15/2011)

    Ahh, sorry guys, it was the mirror deleting the logs too soon. The principle was saying deleting old logs, but the mirror says deleting old logs and gives...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 15, 2011 at 5:35 pm

    #1368908

  • RE: Log shipping deleting log files too soon.

    What time does the restore job run? At the same time as the backup job?

    It would be interesting to change the time and see if this changes the deleted files...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 15, 2011 at 4:30 pm

    #1368882

  • RE: Log shipping deleting log files too soon.

    jprovines (8/15/2011)

    backup_source_directory\\lap8db03\TransactionLogBackup

    backup_destination_directory\\lap8ea03\TransactionLogShippingTemp

    file_retention_period2880

    Are both of these folders being cleared after 2 days? If not which one is being cleared?

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 15, 2011 at 4:18 pm

    #1368875

  • RE: Install SQL SP4 on Active / Active Cluster

    You don't want to have both nodes active when installing the service pack. Usually you would go to Active/Pasive, then remove the pasive node from the cluster.

    I would stick to...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 14, 2011 at 3:26 pm

    #1368417

  • RE: Log shipping deleting log files too soon.

    Like a maintenance task set to delete old tran log backups older than 3 days 🙂

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 11, 2011 at 9:24 pm

    #1367703

  • RE: Rolling back already commited data..?

    Ninja's_RGR'us (8/10/2011)

    Leo.Miller (8/10/2011)

    Another solution would be to set all the queries to use WITH (NOLOCK)

    select * from Test1 with (nolock) where ID_Col = 10

    But I would consider this a bit...

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

    August 10, 2011 at 3:26 pm

    #1366975

Viewing 15 posts - 181 through 195 (of 492 total)