Forum Replies Created

Viewing 15 posts - 571 through 585 (of 616 total)

  • RE: Performing database backups while users are online?

    durai nagarajan (8/30/2012)


    hope i remember u have space crunch issue for backup.

    differential backup is to prevent data loss from the previous full bakup idealy good if it has been done...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Performing database backups while users are online?

    andrew gothard (8/30/2012)


    SQL Server backups of all types are an online operation. Having people working while they occur is no problem ta all. Are you taking log backups...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Backup process - Your feedback required!

    Grant Fritchey (8/29/2012)


    READ ONLY on a database means it no longer bothers maintaining locks because there is not possibility of data modification.

    Makes perfect sense.

    Thanks for the tip! 😉

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Backup process - Your feedback required!

    Grant Fritchey (8/29/2012)


    The one thing I see missing are log backups. You don't list those as the types of backups, but you have databases in FULL recovery. If you're not...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Backup Reporting and job failure monitoring

    durai nagarajan (8/23/2012)


    [quote-0but I'm not sure where to store this database. I'm also unsure of how to get my information from the servers that are outside of the trusted network...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Backup Reporting and job failure monitoring

    durai nagarajan (8/23/2012)


    Database usage report.

    what are you going to do on this?

    Sorry but what I meant was that management would like a report that would give them information on...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Is using Maintenance plans a good idea for this?

    Paul Clark-418949 (8/23/2012)


    Hiya,

    You say these are staging tables...

    Couple of questions then:

    1.) Do these tables get cleared down as part of the staging process?

    2.) If the above is true how often...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Is using Maintenance plans a good idea for this?

    clayman (8/22/2012)


    Abu Dina (8/22/2012)


    Good morning,

    We have 5 SQL Servers used by operations team.

    QBDB01 - 62 Databases

    QBDB02 - 41 Databases

    QBDB03 - 39 Databases

    QBDB04 - 31 Databases

    QBDB05 - 28 Databases

    The databases...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Is using Maintenance plans a good idea for this?

    durai nagarajan (8/22/2012)


    Maintenance plans are built in SSIS packages and T-SQL are sql code.

    both of them has to use jobs to execute at certain intervals or time.

    it is your option...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Is using Maintenance plans a good idea for this?

    durai nagarajan (8/22/2012)


    Can you tell me what is wrong with the current setup?

    what type of data available explain more clearly and what level of data loss is acceptable.

    if the data...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Is using Maintenance plans a good idea for this?

    durai nagarajan (8/22/2012)


    consider the number of DB and data loss acceptability before planning this.

    The databases are merely staging DBs used to perform data cleaning/merging etc.. HD space is not suficient...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Function to split name field

    Thanks CSGuard. I will try and create a CLR implementation if time permits and will report back.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Function to split name field

    Thanks for the feedback GSquared.

    I started off with a small list for my titles but then I added some more from a list of titles I found online 😀

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Help on splitting the name field in a query

    Jeff, I know it's almost 5 years since you posted this solution but if it's any consolation then let me thank you for this code.

    I'm learning so much from your...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: How to escape the ^ symbol in the following function

    Yup, I'm officially a SQL n00b! (http://www.urbandictionary.com/define.php?term=n00b)

    Thanks Jeff, Cadavre & Chris.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

Viewing 15 posts - 571 through 585 (of 616 total)