Forum Replies Created

Viewing 15 posts - 541 through 555 (of 860 total)

  • RE: Back up Schedulling

    Ali Tailor (11/11/2010)

    Vishal.Gajjar (11/11/2010)

    TB = TeraByte??

    You can perform Full Backup Once a Week, Preferably on Weekends,

    and a Transaction Log Backup Every Hour ....,,

    Thanks Vihsal,

    I Answered the Same (Above in quote)...

    November 11, 2010 at 12:37 am

    #1249287

  • RE: Back up Schedulling

    How critical is the application ?

    How much time acceptable in case of DB unavailable?

    How much data loss acceptable (Minimum)?

    Finally, What type of disk level you have in place ? (to...

    November 11, 2010 at 12:33 am

    #1249284

  • RE: Back up Schedulling

    Ali Tailor (11/11/2010)

    Hi

    Say Hey Kid

    Actualy It was typing mistake

    I meen 'One Terebite Plus Database,

    Thanks

    The think is you have to ask couple of questions to the interviewer .

    November 11, 2010 at 12:16 am

    #1249277

  • RE: Back up Schedulling

    Ali Tailor (11/10/2010)

    Hi Gurus

    I asked a question in an InterView as following.

    There is Onle Plus TB Database Yoy are Admin of that datababase;

    What Backup strategy you will adopt...

    November 10, 2010 at 11:52 pm

    #1249266

  • RE: Memory Used by SQL SERVER 2005

    c.ajitkumar (11/10/2010)

    Hi All,

    I am using sql server 2005 standard edition can anybody guide me for

    how to check memory (RAM) usage by sql server .

    Thanks in Advance.

    Reagrds,

    Ajit

    Give me more...

    November 10, 2010 at 11:39 pm

    #1249260

  • RE: Recover database on missing Tlog's

    parthi-1705 (11/10/2010)

    muthukkumaran (11/10/2010)

    Nope not possible.(upto t3)

    Is it production database ?

    Find out its is deleted or moved.

    Hi

    It is not production it is local some one has deleted...

    November 10, 2010 at 6:13 am

    #1248793

  • RE: Recover database on missing Tlog's

    parthi-1705 (11/10/2010)

    Hi

    I am having a Fullbackup (Monday Night) and T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12 log backup in interverl of every 2hr i need to store Full backup and T1 to T12.What...

    November 10, 2010 at 5:46 am

    #1248780

  • RE: login issue

    amar4sk (11/10/2010)

    Issue: SQL Server 2008 is installed with mixedmode and user forget the password for sa account, is there any possible way to connect SQL Server, even tried with Built-in-account's...

    November 10, 2010 at 4:34 am

    #1248760

  • RE: Problem with dbcc shrinkfile(datafile,targetsize)

    DBAsql-1046554 (11/10/2010)

    Thank You so much for your help in this.

    Unused space released back to the drive.

    How you did this?

    November 10, 2010 at 3:25 am

    #1248739

  • RE: Problem with dbcc shrinkfile(datafile,targetsize)

    DBAsql-1046554 (11/9/2010)

    There was no active transaction in the db. Even then space has not released and remains same.

    Any suggestions?

    Read this link

    http://www.sqlservercentral.com/Forums/Topic615488-5-1.aspx

    1.Never ever shrink the tempdb.

    2.Try to change the path...

    November 9, 2010 at 11:45 pm

    #1248684

  • RE: How to list all the objects of another server

    reggae_blur (11/9/2010)

    one last question, do you know how to use SP_HELPTEXT, say I want to get the content of a stored procedure in ServerB by running it in ServerA?

    i tried...

    November 9, 2010 at 11:26 pm

    #1248683

  • RE: Logshipping Restore Job Getting failed.

    Saravanan T (11/9/2010)

    Hi ,

    Thanks for your reply.

    Restore job will be having only one step . And the error I got is "Message

    Executed as user: Ramco\_saran. sqlmaint.exe failed. [SQLSTATE 42000]...

    November 9, 2010 at 11:09 pm

    #1248680

  • RE: How to list all the objects of another server

    reggae_blur (11/9/2010)

    thanks muthukkumaran..

    i tried this SELECT * FROM ServerB.master.dbo.sysdatabases

    it worked! 🙂

    Ur Welcome

    November 9, 2010 at 7:14 am

    #1248270

  • RE: Ways to backup restore Very Large Database (VLDB)

    rajanishvibha 3763 (11/9/2010)

    Hi Sir

    what new in sql server 2005 for backup

    In this forum --> go SQL Server 2005 --> Backups-->Add Topic

    -->then finally ask your queries

    November 9, 2010 at 7:12 am

    #1248267

  • RE: Update Stats job

    SKYBVI (11/9/2010)

    @ mutthu

    The auto update stats is enabled.

    So, I will run the t sql sp_updatestats from hte maintennace tasks and see how it goes..

    Also, I noticed the full daily backups...

    November 9, 2010 at 7:08 am

    #1248264

Viewing 15 posts - 541 through 555 (of 860 total)