Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database Refresh

Author  Topic 

ozsql
Starting Member

14 Posts

Posted - 2009-09-20 : 21:33:21

Hi Guys,

I need to refresh SQL Database. We got three servers

Server (A) Production
Server (B) Replication of Production
Server (C) Development

I need to get the last data to develop few requirements. We need to refresh data on server (B) and then refresh on server (C). On both the servers do I need to right click on database and then click on refresh to refresh database or do I need to run any script? Please can anyone help me out with query, we are using SQL 2008.

Can anyone please provide if any script available

Thanks,

D

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-09-21 : 00:01:44
Dupe:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=133121
Go to Top of Page
   

- Advertisement -