What are the challenges you face when working across database platforms? Take the survey

Restore to standalone server

garybgaryb Posts: 10
edited February 14, 2008 9:37AM in SQL Backup Previous Versions
I have SQL2000 standard server in remote datacentre with 6 DBs approximately 2GB of data + logs. I have setup SQL backup as follows:

MON<> FRI - 02:00 Full DB backup
MON <> FRI - Hourly from 08:00 until 18:00 log backup

As a test I xipped the files and copied across WAN to our local dev server, created a new DB and started restore process. All goes well but have a few questions if I may?

1 - What account does it run under. I have to always change to Windows login when creating backup or restore jobs but back to SQL for actual backup/restore scheduled process? Odd..
2 - We have a DB login called "Staff" in teh security tab of EM. When restoring to local server I have to remove that login form the actual DB sysuser table, then go back to security tab and check all DB permissions, is this normal?

Thanx for your time

Sign In or Register to comment.