Forum Replies Created

Viewing 15 posts - 46 through 60 (of 67 total)

  • RE: TDE and Backups

    This one was easy.. I got it right......:-)

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 21, 2011 at 3:24 pm

    #1371210

  • RE: Master Database

    good question to test the basics 🙂

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 20, 2011 at 11:42 am

    #1371077

  • RE: Connecting to R2

    Yes, you can connect to SQL Server 2008 R2 instance from SQL Server 2008 SP1 client.

    Make sure you have opened firewall for settings fro SQL Server to be connected from...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 20, 2011 at 11:23 am

    #1371073

  • RE: How well do you know MAX?

    tricky question 🙂

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 9, 2011 at 1:42 pm

    #1366240

  • RE: Memory Issue

    Today nly i was reading the below linked articles. I hope it will help you .

    http://www.mssqltips.com/tip.asp?tip=2454

    http://www.mssqltips.com/tip.asp?tip=1917

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 9, 2011 at 1:02 pm

    #1366189

  • RE: TOP 1000 rows

    Is it a simple select query or do it contain joins?

    how much data is there in the table from which you are trying to retrive 1000 rows?

    Is "where" or "order...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 9, 2011 at 1:00 pm

    #1366184

  • RE: what we have to do when sql server agent was down

    Do you want to get notified when SQL Server agent goes down?

    or

    You want to know the steps/action to perform in order to restart this service?

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 9, 2011 at 12:57 pm

    #1366179

  • RE: Restore question

    There is no way, one data file will be shared by multiple databases.

    You can alternately run 'sp_helpdb dbname' to check the current logical and physical file name/[ath of the...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 8, 2011 at 5:28 pm

    #1365599

  • RE: Not able to connect to SQL 2008

    Can you please share the error message?

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 4, 2011 at 1:07 pm

    #1363916

  • RE: sql job to backup and restore db automatically

    To restore a database successfully, there should not be any other connection to that DB.

    Now to answer your questions:-

    Any options for the sql scripts that can force to restore and...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    January 3, 2011 at 7:44 am

    #1268472

  • RE: Remember password is not remember on ever time

    may be some one have revoked your access. please check with your administrator to check if your id still have access or not. 🙂

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    September 7, 2010 at 12:09 am

    #1217122

  • RE: DB Recovery

    Since no backup is taken after changing the recovery model / after inserting records.. so no way you can recovery any data in this DB....

    I believe something is missing in...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    September 1, 2010 at 1:33 am

    #1214772

  • RE: Database Snapshots

    I also beileve, beetr take a fresh snaphot

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    September 1, 2010 at 1:26 am

    #1214767

  • RE: Sql keeps sending Event Id 18264 to the windows log

    If I am correct, your issue is as why this test database got backed up. Since you haven't cretaed any backup job/updated MP for this database.

    To answer, just check all...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    August 16, 2010 at 2:25 am

    #1207203

  • RE: Alert or Alarm e-mail when cluster fails over

    skhan-680833 (3/16/2010)

    Is there any way to set up and alert using DBmail when the cluster fails over?

    Or any other option to send an alert when the cluster fails over.

    Thanks

    SDKhan

    Hi, you...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

    March 16, 2010 at 11:57 am

    #1134694

Viewing 15 posts - 46 through 60 (of 67 total)