Forum Replies Created

Viewing 15 posts - 61 through 75 (of 146 total)

  • RE: Reindex minimally logged - Does not work

    Carl Federl (4/22/2010)

    The log files growth is the same as when it is in full mode

    Do you mean the size of the database log file ( ldf extention) or the...

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 23, 2010 at 12:07 am

    #1156616

  • RE: Reindex minimally logged - Does not work

    pshaship (4/22/2010)

    I

    see that you are rebuilding when > 30% fragmented and reorganizing < 30% - but are you limiting that to only tables with more than 1000 pages?

    why only...

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 22, 2010 at 11:27 pm

    #1156607

  • RE: Reindex minimally logged - Does not work

    Largest is 4.9Gig

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 21, 2010 at 11:36 pm

    #1155851

  • RE: Reindex minimally logged - Does not work

    I have 2000, 2005 Ent and 2008 Ent.

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 11:20 pm

    #1155106

  • RE: Reindex minimally logged - Does not work

    Thanks for the suggestion on how to do reindexing but I still have the problem. It is very important in my enviroment to find a solution to this problem.

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 11:02 am

    #1154791

  • RE: Reindex minimally logged - Does not work

    Yes I do. This is only a problem with logshipping databases. I only have 4mb line to offsite.

    I think I saw something once that said if some backup is running...

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 4:39 am

    #1154447

  • RE: SQL Job

    Sorry here is the full select

    use master

    select * from sysprocesses where spid > 50 and program_name like 'SQLAgent - TSQL JobStep%'

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 4:11 am

    #1154436

  • RE: SQL Job

    Hi

    The next step is to check the sysprocess table. Look for something like "SQLAgent - TSQL JobStep............" ...

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 4:02 am

    #1154433

  • RE: SQL Job

    Try this script and see if the job is still in the table:

    select * from sysjobs

    What kind off condition are you looking at. Here I am thinking that there could...

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 3:27 am

    #1154414

  • RE: Reindex minimally logged - Does not work

    The log files growth is the same as when it is in full mode. I see logfiles that grow up to 18 gigs in one hour while reindex is happening.

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 3:19 am

    #1154410

  • RE: Archiving an area of an enterprise sized SQL server 2005 DB

    Hi

    For the sp that use the table you can run the following script.

    select name from

    sys.sql_modules join

    sys.objects on sys.sql_modules.object_id =

    sys.objects.object_id

    where definition like'%tablename%'

    order by name

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 3:14 am

    #1154409

  • RE: SQL Job

    1. Where did you setup the Alert?

    2. What version suppose 2005

    3. Check - select * from sysalerts in msdb

    4. Is it perhaps logshipping

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 2:30 am

    #1154388

  • RE: Log shipping and Reindexing issue

    Add step to the Reindex job to run logshipping backup job and then you can use DBCC shrinkfile to shrink the log file. You can also put the DB in...

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    April 20, 2010 at 12:16 am

    #1154337

  • RE: Sub table implimentation problem

    Hi

    I found the answer after a bit of trile and error.

    thanks

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    March 23, 2010 at 12:18 am

    #1137986

  • RE: #VALUE! when exporting report to XLS (only)

    Thanks for the work around. Must be some kind of MS bug.

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    March 16, 2010 at 12:05 pm

    #1134701

Viewing 15 posts - 61 through 75 (of 146 total)