Forum Replies Created

Viewing 15 posts - 31 through 45 (of 859 total)

  • RE: Backup a database which is in restoring mode

    gmamata7 (11/2/2009)

    Hi,

    I have a Log shipping configured database and on secondary the database is in restoring mode & log backups are applying every 15 mins. Is there any way...

    November 3, 2009 at 12:00 am

    #1074121

  • RE: SQLmon- Third Party tool

    Hi mascot,

    Thanks for your reply. Yes, we are going to have a technical session scheduled.

    How do you do hardware estimation WRT the same? What factors do you have to...

    October 28, 2009 at 11:35 pm

    #1072241

  • RE: how to analyse deadlock graph and deadlock xml ?

    anjali.vishwakarma (1/23/2009)

    I am attaching deadlock graph and deadlock xml. How to analyse it and what'll be the solution to avoid deadlock in future ?[/img]

    Anjali, please search through this forum before...

    October 12, 2009 at 5:02 am

    #1064652

  • RE: backup error

    dba-vb (9/14/2009)

    hi,

    i'm getting this error:

    recently we have enable FTS(Fulltext search)

    Executed as user: NT AUTHORITY\SYSTEM. The backup of the file or filegroup "sysft_ARTICLE_desc" is not permitted because it is not online....

    September 14, 2009 at 7:33 am

    #1053191

  • RE: New installation requires same settings as the previous installation

    luckysql.kinda (9/14/2009)

    I work as a database administrator and need to install a new SQL Server 2005 instance on a newly installed Windows Server 20003 server named LuckySql. This new instance...

    September 14, 2009 at 7:31 am

    #1053189

  • RE: recovery and norecovery

    Paul White (9/10/2009)

    The difference between RECOVERY and NORECOVERY is, briefly, that RECOVERY rolls back any uncommitted changes (this is called UNDO).

    Does it not roll forward all the committed changes,...

    September 12, 2009 at 1:14 am

    #1052674

  • RE: how to recover data from server crash or hard disk crash

    vinod.km (9/10/2009)

    Hi,

    I have SQL Server 2005 database which has very important data. For protection of data I am following Full Recovery model So that I can take the tail...

    September 12, 2009 at 12:53 am

    #1052673

  • RE: Resource Database backup

    Rem (9/11/2009)

    Hi,

    What is the best method to backup Resource Database? Does someone already has a script for it?

    I just realize that this databases is not taken in backup.

    Thanks,

    It doesn't...

    September 12, 2009 at 12:09 am

    #1052672

  • RE: New Server

    Tara (9/11/2009)

    i am planing to setup new sql server and in the process of gathering requirements to setup powerfull sql server. To start with could someone let me know what...

    September 11, 2009 at 11:51 pm

    #1052670

  • RE: How to stopt/Disable log shipping

    gmamata7 (9/11/2009)

    Why dont you stop the already configured logshipping?

    How to do that? could you please explain me..

    Sure, instead of me explaining the same thing...It's discussed over here ..please take a...

    September 11, 2009 at 11:43 pm

    #1052669

  • RE: i want restore a sql200db to sql2005.

    charipg (9/11/2009)

    i want to restore a sql2000db to sql2005.

    should take any prerequisites?

    Nothing much really..

    You do have some post-requisites that you need to follow once after restoring to SQL 2005...

    You...

    September 11, 2009 at 11:31 pm

    #1052667

  • RE: How to stopt/Disable log shipping

    Why dont you stop the already configured logshipping?

    September 11, 2009 at 11:22 pm

    #1052664

  • RE: TRN Log File Size Assistance

    Cathy DePaolo (7/15/2009)

    Hi Krishna. Thank you for your reply.

    Krishna Potlakayala (7/15/2009)

    Cathy DePaolo (7/15/2009)

    I'm not sure if I should shrink the file or not, because I seem to remember...

    July 15, 2009 at 1:55 pm

    #1025336

  • RE: upgradation methods

    ramyours2003 (7/15/2009)

    what are the upgradation types we ve in sql i.e sql2000to 2005 viceversa and what are the preventions and down time required should we take while upgrading...

    July 15, 2009 at 12:41 pm

    #1025279

  • RE: TRN Log File Size Assistance

    Cathy DePaolo (7/15/2009)

    I'm not sure if I should shrink the file or not, because I seem to remember an article or post indicating that shrinking the trn file is...

    July 15, 2009 at 12:36 pm

    #1025275

Viewing 15 posts - 31 through 45 (of 859 total)