Database refresh

19 Jan 2006 4:51 PM

David

Hi,

I want to refresh one of the database from production server to QA server
every first day of the month. How can I do it through scheduling a job? Any
one has scripts handy?

Also, will it transfer all the logins when I refresh the database. If not,
how can I achieve this task too?

Thank you guys

20 Jan 2006 5:57 AM

Uri Dimant

David

You asked two questions

1)
Perform BACKUP /RESTORE DATABASE somethng like that

BACKUP DATABASE myname TO DISK =
N'\\Remote(QA)\backup\myname .BAK'

Create a job which executes this command , just make sure that you drop the
old verison of your database on QA server\

2)
Search on internet for "sp_help_revlogin" stored procedure provided by MS to
move logins

Show quoteHide quote

"David" <Da***@discussions.microsoft.com> wrote in message
news:CA6FF754-AA50-46D3-9BD6-0FF8594AD2AA@microsoft.com...
> Hi,
>
> I want to refresh one of the database from production server to QA server
> every first day of the month. How can I do it through scheduling a job?
> Any
> one has scripts handy?
>
> Also, will it transfer all the logins when I refresh the database. If not,
> how can I achieve this task too?
>
> Thank you guys