Forum Replies Created

Viewing 15 posts - 91 through 105 (of 468 total)

  • RE: Restricting a backup from restore

    The only way I could think of is using an external backup compression/encryption software like Arc serve..

  • RE: Identity column limitation

    Dugi (1/12/2010)


    Vivek29 (1/12/2010)


    After 2 billion insertions or max of the datatype limit the identity column has reached what will happen and how to tackle that?

    Did you reach a 2 billion...

  • RE: data file for tempdb very huge

    Click here[/url] and here for articles on how to manage tempdb growth.

    Also, if your tempdb has grown to that big a size, then something must have run that needs that...

  • RE: sql server 2005 vs sql server 2008

    A complete list of features in SQL 2008 can be viewed here

    Listed below are some of the very good features for a DBA..

    Transparent Data Encryption --> The ability to encrypt...

  • RE: Setting up Database mail using gmail account

    Good post. I was able to configure database mail successfully to my gmail account. But, when I send a message it says 'Message Queued' and I did not receive any...

  • RE: Restoration of SQL 2005 database across builds

    Any SP or Cu or hotfix would address issues or provide enhancements to the installation of SQL server and how it manages the db operations. This should be sufficient to...

  • RE: Update over linked servers slow

    Try a look at this KB article here. May be you can relate it to your problem

    Thanks..

  • RE: Reducing the Data and Log file Size in SQL SERVER 2005

    nikhil.verma (1/11/2010)


    Hello

    In my Production Envrionment , for most of the databases ( SQL SERVER 2005) the recovery model is set to SIMPLE. Our Monthly analysis showed that database backup sizes...

  • RE: Update over linked servers slow

    If you are running queries that join between tables in the two server instances, and transferring large amounts of data, then you have a bottleneck that you need to be...

  • RE: Missing green arrow on the sql server icon in object explore

    Schadenfreude-Mei (1/8/2010)


    pankaj.baluni (1/8/2010)


    Try to re-install the latest service pack.. just uninsall and re-install the SP.

    On my desktop machine or the 2005 server?

    Doesn't look to me that it is a service...

  • RE: Log Shipping

    Ignacio A. Salom Rangel (1/11/2010)


    George, I know that the solution you gave helped to solve the problem, but I found it far more important to figure out what happened to...

  • RE: Log Shipping

    Ramji29 (1/11/2010)


    Guys one more thing.. if I restore differential backup on secondry in place of full backup will it work???

    Sudhakara it's always a good practice to post the solution also...

  • RE: Hotfix Problem

    Tara-1044200 (1/11/2010)


    Update on this problem;

    I can not even connect to Integration services on this servers, i get the error that says

    TITLE: Connect to Server

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

    Cannot connect to OBBEAVER.

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

    ADDITIONAL INFORMATION:

    Failed to...

  • RE: Today's Random Word!

    speed

  • RE: sql server 2005 vs sql server 2008

    Vivek29 (1/11/2010)


    Thanks...but this is not exactly what I am looking for. Listing few points of what and why will help?

    Only depends on what your trying to use. From the Development...

Viewing 15 posts - 91 through 105 (of 468 total)