SQL Server Performance

this is about refreshing a database

Discussion in 'SQL Server 2008 Replication' started by srikanthamk, Dec 21, 2009.

  1. srikanthamk New Member

    hi,
    this is srikanth, i got a question , i.e. how do u refresh a database from production server to the development server while the database is in replication. reply me plz
    thanks an Regards
    srikanthamk, Dec 21, 2009
    #2

  2. shashank sharma New Member

    shashank sharma, Dec 21, 2009
    #3

  3. satya Moderator

    Welcome to the forums.
    If you need to refresh the database between the environments on regular basis then REPLICATION is useful for the required tables, if you need the complete database then you can follow as Shashank suggested by using BACKUP/RESTORE methods. On top of this you must think about credentials and sensitive data that might be visible for other that is not supposed to be.
    satya, Dec 22, 2009
    #4

  4. ghemant Moderator

    shrikanth do you have replication on your dev server? if so, please use keep replication while restoring database.
    regards
    ghemant, Dec 23, 2009
    #5

Share This Page