Forum Replies Created

Viewing 15 posts - 316 through 330 (of 442 total)

  • RE: How to recover a dropped table

    Yup....thats what I thought. Thanks.

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • RE: How to find the database size from a full backup?

    Thanks Lowell.

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • RE: Converting Oracle DDL statments to SQL

    Lowell (11/21/2012)


    if you want to do it yourself, which is another big job let me tell you, this data type equivalents link can help:

    http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm

    I've done it the other direction:...

    Regards,
    SQLisAwe5oMe.

  • RE: Converting Oracle DDL statments to SQL

    Lowell (11/21/2012)


    SQLCrazyCertified (11/21/2012)


    I need to create a sql database which works the same way in oracle....

    Basically, I have to mimic a database from Oracle to SQL server.

    I have the DDL...

    Regards,
    SQLisAwe5oMe.

  • RE: Capacity Planning

    bjcharles (11/9/2012)


    Some of the info I gather on a central reporting server are about: disk space, db size (mdf, ldf), memory usage, I/O, network, CPU, user sessions. Easiest way for...

    Regards,
    SQLisAwe5oMe.

  • RE: How to check mirrored database

    Ohk....thanks Perry.....didn't know that.

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • RE: How to check mirrored database

    shohelr2003 (11/21/2012)


    Thank you, so nothing to be worried.

    You should also see next to the principal db says "synchronized"

    Since you have witness server, I am thinking, you configured with synchronize mode.

    Regards,

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • RE: Regarding Cluster Failover

    From eventvwr, I see this....

    "A fatal error occurred while reading the input stream from the network. The session will be terminated."

    I also see another error every 4 mins or...

    Regards,
    SQLisAwe5oMe.

  • RE: 64-bit vs 32-bit SQL 2008 and development

    Rod at work (11/16/2012)


    I'm configuring a new PC, which is a 64-bit architecture/OS. I'm doing some development on this box using SQL Server 2008 R2 Express. As I do...

    Regards,
    SQLisAwe5oMe.

  • RE: How to find a table is locked or not?

    GilaMonster (11/13/2012)


    Grow the files, not increase the autogrow increment.

    Autogrow is for when the DBA has messed up and not noticed that the DB files are nearly full and need to...

    Regards,
    SQLisAwe5oMe.

  • RE: How to find a table is locked or not?

    GilaMonster (11/13/2012)


    Justify it on the basis that no maintenance is just plain bad practice.

    If the DB is nearly full, you need to grow the files.

    Thanks Gail, I have increasted the...

    Regards,
    SQLisAwe5oMe.

  • RE: How to find a table is locked or not?

    GilaMonster (11/13/2012)


    You can check if there are any locks at all on a table by looking at the sys.dm_tran_locks table, but somehow I don't think that's the real question here.

    Thanks,

    After...

    Regards,
    SQLisAwe5oMe.

  • RE: SQL 2005 SSIS package error

    [/quote]

    Purchase it?[/quote]

    I have verified that this is a Enterprise Edition (64-bit), so, it is not a licensing issue.

    Regards,

    SueTons

    Regards,
    SQLisAwe5oMe.

  • RE: Mirroring DR Test Failover/Failback

    Superdoc (10/25/2012)


    Make sure the mirroring is in "High Safety" - Synchronous mode, usually it is just in seconds the data is transferred from and to mirror so there is almost...

    Regards,
    SQLisAwe5oMe.

  • RE: Search functionality issue.

    Vegard Hagen (10/23/2012)


    Actually, if we're talking about full-text search catalogs and that's what is not refreshing, than yes, I'd say that's probably it and I'm probably the one who was...

    Regards,
    SQLisAwe5oMe.

Viewing 15 posts - 316 through 330 (of 442 total)