Forum Replies Created

Viewing 15 posts - 2,266 through 2,280 (of 4,745 total)

  • RE: How to dump a table from a Prod database to a dev database

    good old BCP utility.

    ---------------------------------------------------------------------

  • RE: sql 2005 (32bit) on Windows Server 2003 (64bit) AWE enable?

    As SQL2005 standard edition 32bit is inherently capable of using more than 4GB I don't see why it cannot in this scenario.

    quite prepared to be proved wrong though. Perhaps MrAkki...

    ---------------------------------------------------------------------

  • RE: Log Shipping

    presuming your problem is not one of the obvious ones above, can you give us a quick description of you in-house written log shipping set up?

    sounds like this is not...

    ---------------------------------------------------------------------

  • RE: sql 2005 (32bit) on Windows Server 2003 (64bit) AWE enable?

    sqlbuddy123 (9/20/2010)


    SQL Server 32 bit can't use more than 4GB of memory. Please use AWE setting for the 32-bit SQL Server and Lock Pages in Memory setting if it is...

    ---------------------------------------------------------------------

  • RE: Log Shipping

    so your two posts refer to the same problem? Could you refer people over to here, it has more info.

    ---------------------------------------------------------------------

  • RE: Log Shipping

    does this relate to your other log shipping post andrew?

    Full backups do not affect the log chain. the full has not had a step added to truncate the log has...

    ---------------------------------------------------------------------

  • RE: Log Shipping Delete Old Files Process

    AndrewSQLDBA (9/20/2010)


    Hello Everyone

    Is there a way to NOT have the older log files deleted? I would rather delete the files thru a SQL job.

    Some days the Log Shipping will get...

    ---------------------------------------------------------------------

  • RE: sql 2005 (32bit) on Windows Server 2003 (64bit) AWE enable?

    I don't have this set up and it is another variation on many possible configurations, but I do not see why this will not work.

    SQL2005 standard 32bit can support memory...

    ---------------------------------------------------------------------

  • RE: error log in sql server2005

    raiseerror goes to the SQL error log.

    How is this stored procedure going to be run?

    ---------------------------------------------------------------------

  • RE: error log in sql server2005

    if you mean you want this in the SQL error log and windows event log use the raiseerror command

    Else the print or select command?

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/20/2010)


    Monday came too early this week. Too many chores.

    Its been monday here for hours.

    ---------------------------------------------------------------------

  • RE: Error log in sql server 2005

    duplicate post.

    answers to http://www.sqlservercentral.com/Forums/Topic989315-145-1.aspx please

    ---------------------------------------------------------------------

  • RE: Is there any way to find who deleted the database

    should be in the default trace in your log directory.

    ---------------------------------------------------------------------

  • RE: SQL Server DB Tools

    swethak13 (9/19/2010)


    Is there any standard approach in the ways to administer the SQL Server databases. As I am new and have no experience in these I don't know where to...

    ---------------------------------------------------------------------

  • RE: SQL Server DB Tools

    Hardy21 (9/19/2010)


    SQL Server provides lots of tools to administer the database.

    SQL Server also provides facility to take backup with "Compress" option. So backup size is small.

    You can take backup in...

    ---------------------------------------------------------------------

Viewing 15 posts - 2,266 through 2,280 (of 4,745 total)