Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Update Statistics and Backup

    Ok, then what is the issue, get the data in SQL then you can start maintain it.

    By the way, how big is the data?

  • RE: Update Statistics and Backup

    Ok, I think one Oracle DBA can answer about this more how the Statistics will add advantage.

    You can google and you may get lot of links for that. Even I...

  • RE: Update Statistics and Backup

    Any specific reason you want statistics included in backup? If so, please update statistics and take backup, otherwise, you can do either option.

    While taking backup, nothing is updated, Backup operation...

  • RE: I get invalid object name

    You might have received Object name as well. Can you share that, it would be helpful to check the object and its use.

    -Johnson

  • RE: Can model system database's size ever increase?

    Yes as said, if anyone add any objects in model which needs to be there when DBA create a new DB.

    In SQL 2008 onwards, the recovery model is full, which...

  • RE: Transaction log getting bigger?

    Other option is,

    you can use the Option 'Auto Shrink' in the "Database->Properties->Options"

    But this will affect the performance.

    Second option is, use

    dbcc shrinkdatabase (databasename,truncateonly)

    this will shrink only logs, and return back the...

Viewing 6 posts - 1 through 6 (of 6 total)