Forum Replies Created

Viewing 15 posts - 241 through 255 (of 2,436 total)

  • RE: Database Mail sending fail after restoring MSDB from another server.

    Please try sending a test email via the GUI and post the screen shot of the error.

    Also, try sending a test email via the query window and post the ewrror...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: No catalog entry found for partition ID

    I believe that 'Database 2' is tempdb.

    Try stopping and restarting SQL Server.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Managing Useful Scripts and Articles

    Google docs anybody ???

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Can I determine SQL install date using a TSQL script?

    How about one more solution:

    use master

    go

    select createdate as 'Sql Server Installation Date'

    from sys.syslogins

    where sid = 0x010100000000000512000000 -- language neutral for NT AUTHORITY\SYSTEM

    go

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Database Mail sending fail after restoring MSDB from another server.

    try this:

    stop the SQL Agent

    execute the following query:

    alter database msdb set enable_broker

    restart the SQL Agent

    Even though the Service Broker may not be installed I have found...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: SSMS Oddity (ies)

    I can replicate it. I have attached the screen shot as well.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Our backups are getting too big and are causing us problems!

    Also ...

    Our database backup throughput to local or SAN disk is about 1 Gb/Minute.

    Our network database backups average about 500 Mb/Minute.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Our backups are getting too big and are causing us problems!

    I really think that your network has issues ...

    We toss around Terrabytes of data fairly regularly.

    Our network throughput in copy these 200-500 Gb backup files ranges anywhere from 375 Mb/Minute...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Uptime = Downtime? (Database Weekly, Aug 3, 2009)

    It seems to be more of a case of avoiding 'planned downtime' in order to increase 'availability' while at the same time increasing the possibility and length of 'unplanned downtime'....

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Designing Hardware for 40 Terabyte system

    Please take Ed's advice ... the money you will spend on experienced consultants with the knowledge-base you need will be paltry (50-100k) compared to the millions your servers, SAN storage...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Install SQL 2005 Entrprise IA64X on windows 2003 Cluster

    I am going to guess that you are installing from a network share.

    If this is the case copy the installation media to local disk and try it again.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: SQL Server vs. JET

    Interesting - I had the chance to work with a few Exchange ROSS and SQL ROSS engineers over the last decade at various stops in my career. It seemed that...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Database Backup Failing, not sure why

    Since this is a maintenance plan try querying the msdb maintenance history table:

    select * from msdb..sysdbmaintplan_history

    where plan_name = 'your_plan_name'

    I have found that this table sometimes has better info than the...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: I Want a Database

    It sounds like Gordon Bell is doing exactly what he and MS want - sometyhing 'fun' and definitely outside of the box. My hat is off to him and MS...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Spatial Concepts

    It took google and wikipedia 60 seconds to provide the answer for me.

    At first I thought what in the world does this have to do with SQL - then started...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 241 through 255 (of 2,436 total)