Forum Replies Created

Viewing 15 posts - 17,431 through 17,445 (of 39,903 total)

  • RE: Need assistance in reconfiguring our backup jobs

    I tend to side with Michael, though if you don't want to touch what the old DBA did, you could add in transaction log backups every 15 minutes and then...

  • RE: Talking baseball

    Jeter signs (http://sports.espn.go.com/new-york/mlb/news/story?id=5884052), though I think they overpaid a bit.

    Still, glad he's still a Yankee.

  • RE: Poor Restore Times

    I don't think that you'd get substantially better performance on SS2K8, but if you want (and have time) install Dev edition on the same hardware and test that.

  • RE: Quick Question.

    Not a lawyer, but my understanding is that standby servers not being used do not need a separate license.

  • RE: Poor Restore Times

    Are you restoring across the network?

    While the backup/restore should be faster in SQL 2005+, I'm not sure it would make a huge difference. Compressing the backups (reducing i/O) and having...

  • RE: cannot login sql server as an administrator

    Did you change anything else? Did you add a deny login for any group?

    Are you sure your Windows account is still a local administrator on the server? Did you verify...

  • RE: LIKE and = Operators

    I updated the explanation to the SS@K8 R2 documentation

  • RE: Are the posted questions getting worse?

    Kit G (12/6/2010)


    Steve Jones - SSC Editor (12/6/2010)


    ... It's actually impossible to get a real person at google.

    Ah ha! I knew it! Google is run by Space Aliens!

    They...

  • RE: Are the posted questions getting worse?

    I'm not saying that GoDaddy is right or wrong, just that mail is hard. And shared mail is harder and extremely frustrating.

    They are a large company, and they run into...

  • RE: Are the posted questions getting worse?

    Luke L (12/6/2010)


    I stay away from GoDaddy because of their commercials. To me, they scream "We don't actually know what we're doing and we're hoping you don't either."

    .....

    Based on my...

  • RE: Database Engine!

    Steve Jones - SSC Editor (12/6/2010)


    The system databases are:

    master, model, msdb, tempdb, ReportServer, ReportServerDB

    You can identify them with an IN clause

    ...WHERE name not in ('master', 'model', 'msdb', 'tempdb', 'ReportServer', 'ReportServerDB')

    The...

  • RE: Today's Random Word!

    crookj (12/6/2010)


    Water Pump - Replacing it in my old car today. Hope it works!

    Joe

    Good luck. That's a messy job. Hopefully you'll come out unscathed, unlike me. I stabbed a finger...

  • RE: Question about transactional replication to different DBs

    You have to reinitialize the subscription, which you can do from backup, but that doesn't mean that you need to move the whole db. You just need to move the...

  • RE: Database mirroring?

    What are you referring to? please write more information, and explain exactly what you are trying to accomplish.

    You cannot setup mirroring to/from SQL Server 2000 instances.

    If you have databases...

  • RE: help me code for trigger:

    Please also try to solve this yourself. We are more than willing to help, but we are not here to do your work, or homework.

Viewing 15 posts - 17,431 through 17,445 (of 39,903 total)