#SQLHelp

11 Comments

• 

  Beardslee Hillike

  December 23, 2011 at 8:48 am Reply

  That is really fascinating, You’re a very skilled blogger. I have joined your feed and stay up for in quest of more of your magnificent post. Additionally, I have shared your site in my social networks

• 

  Wilford

  January 25, 2012 at 5:12 am Reply

  Good day! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept chatting about this. I will forward this write-up to him. Fairly certain he will have a good read. Many thanks for sharing it on http://www.sqlserverblogforum.com !

• 

  Jack

  February 15, 2012 at 8:19 am Reply

  Aw, this was a really nice post. In idea I would like to put in writing like this additionally – taking time and actual effort to make a very good article… but what can I say… I procrastinate alot and by no means seem to get something done.

  • 

    Ali

    March 17, 2012 at 7:28 am

    The truth just shneis through your post

• 

  Joel Edgeger

  February 26, 2012 at 9:43 pm Reply

  Good article

• 

  ashish

  June 6, 2013 at 10:03 am Reply

  please Solve my query

  one of my silverlight application is running.
  this application has one central database(sql server 2008).
  and three others database at client side.
  our requirement is whithout changeing in silverlight application
  when we make change in central database(insert update and delete in multiple tables) these change
  automatically happened in all client database.
  and when any change made in any client database all client as wll as central database should be updated automatically.

  For this i read some about Sync Framwork and SQL Server 2008 Change Tracking.
  but i have no idea about how i will do this.
  Please help me. how can we acchive this.

  • 

    Muthukkumaran kaliyamoorthy

    June 6, 2013 at 1:42 pm

    This case you can go for replication. I suggest you to ask this in forum you can get an idea and more opinion.

    SQLServerCentral (http://www.sqlservercentral.com/)

    MSDN (http://social.msdn.microsoft.com/Forums/en/category/sqlserver/)

• 

  MARTIN

  September 22, 2014 at 5:20 pm Reply

  hi

  (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server

  I restored a backup which i was not created to a new database and if i connect above said issue is coming , if i generate script from restored DB and running without data in another new database and connecting to the same is working .. can you plz tell what will be the exact problem and i found one database level user is there as below in the script.

  CREATE USER [appointment_bee] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]

  kindly let me know whats the problem ..

  • 

    Muthukkumaran kaliyamoorthy

    October 13, 2014 at 7:18 pm

    The “error: 40” will come lots of cases, you need to check and go step by step. But check is the server is UP and TCP/IP is enabled.

    http://blogs.msdn.com/b/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx

• 

  aryan

  February 26, 2016 at 2:46 pm Reply

  Please Solve My query
  My server databse recovery option is set to simple
  I am running another software on pc based on sql databse
  I want to know that when I take backup of data , is transaction logs deleted or zippied ?
  In this case Can I recover deleted or modified rows of sql table in database

  • 

    Muthukkumaran kaliyamoorthy

    February 27, 2016 at 1:29 pm

    I suggest you to read a transaction log management.
    The t-log file play a major role in every DB, all the writes are written here and later it moved to data file. It’s very important for recover purpose.

    Now coming to your question:

    1. T-log file will not “deleted or zippied” any of the recovery model. In simple internally it overwrites the committed transaction/inactive VLF , meaning it will reuse the inactive VLF so on … like a circular.
    http://www.sqlserverblogforum.com/2011/03/difference-between-truncating-and-shrinking-the-transaction-log-file/
    http://www.sqlserverblogforum.com/2011/06/sql-server-recovery-models-and-backup-types/

    “In this case Can I recover deleted or modified rows of sql table in database”
    2. It depends on your backup strategy. If you have a table in the full or differential backup, yes you can restore. Since, you cannot take a log in simple mode. This why for high RPO DB, we place the DB in full and run frequent log backups and PITR too.