Forum Replies Created

Viewing 15 posts - 28,321 through 28,335 (of 49,552 total)

  • RE: SQL server Full Backup

    SQL Server 2003? No such version.

    Backup your databases using a database backup tool. Native backup or a 3rd party tool like SQLBackup (Redgate) or Litespeed (Quest). Do not back databases...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 1:58 pm

    #1275565

  • RE: Where do you look for DBA's?

    You asked. I'll try and be gentle.

    Ferguson (1/19/2011)

    Responsible for all physical and some logical administration of Microsoft SQL Server databases, this position will also be a backup DBA for i5/OS...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 1:43 pm

    #1275556

  • RE: Are the posted questions getting worse?

    Craig Farrell (1/19/2011)

    The worst of those is trying to figure out the 'Job Description written for Bob'.

    I've had one of those for me before (long reason why). The...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 1:26 pm

    #1275547

  • RE: .mdf / .bak / .ldf

    sqlserver12345 (1/19/2011)

    .dfb-diff backup files

    Never heard that one before

    .mdb - master database backup...Is .mdf used only for the backup of the master database?

    Nor that one. MDB is usually an MS...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 1:22 pm

    #1275544

  • RE: Retore to create a different DB

    kd11 (1/19/2011)

    Logical file 'testa_TestIIS_Data' is not part of database 'testa_testiis'. Use RESTORE FILELISTONLY to list the logical file names.

    It didn't say use sp_help DB. Use RESTORE FILELISTONLY to list the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 12:57 pm

    #1275529

  • RE: DMV query to get at data stored in tempdb tables, as well as metadata information on currently active tempdb tables

    No. You cannot query temp tables that were created in other connections.

    Offhand don't know about the second, try sys.partitions or one of the related DMVs (sys.dm_db_partition_stats or something like...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 12:44 pm

    #1275522

  • RE: Where do you look for DBA's?

    Craig Farrell (1/19/2011)

    In this case, I would recommend they go to microsoft.com, look under the MCM list, and start making phone calls directly. It's not a matter of the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 12:41 pm

    #1275517

  • RE: Retore to create a different DB

    Define 'didn't like it'

    I can't read your mind, I can't see your screen and I can't run the command to see what's wrong as I don't have (or want) your...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 12:28 pm

    #1275508

  • RE: Where do you look for DBA's?

    Craig Farrell (1/19/2011)

    Hm, interesting find, Ninja.

    There are a number of concerns, from my perspective, with that posting.

    In summary, and with additional comments based on recent job adverts I've...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 12:22 pm

    #1275503

  • RE: Picking topics to blog about

    Keith Langmead (1/19/2011)

    What I was wondering is how or where do people come up with their ideas. Do you simply write about things you come across in your day to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 11:58 am

    #1275497

  • RE: Retore to create a different DB

    Yup. You'll probably have to use the WITH MOVE syntax to create new files for the new DB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 11:54 am

    #1275496

  • RE: $2M worth DW infrastructured set to be releases

    Sure it's Denali (which is in early CTP) and not SQL 2008 R2 Parallel datawarehouse edition (that's what Data Allegro became iirc)

    p.s. Denali has no official name yet, so you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 11:48 am

    #1275493

  • RE: Difference between Lazywriter and checkpoint

    Right, now that I have time to write complex answers...

    Sachin Nandanwar (1/19/2011)

    If Lazywriter is supposed to "age out" dirty pages from data cache to the disk then what does checkpoint...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 11:46 am

    #1275488

  • RE: Unlimited growth for logfiles

    There's no solution because there's no problem. Check the ones that won't accept unlimited and calculate the actual size limit. You'll find it's 2 TB. 2TB is the maximum size...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 11:44 am

    #1275484

  • RE: Clustering & Sys catalog

    What info specifically? I don't think there's much in SQL, it's more an OS-level thing afaik.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 19, 2011 at 11:40 am

    #1275481

Viewing 15 posts - 28,321 through 28,335 (of 49,552 total)