Are you tring to restore using EM? Under options, I can't see file groups showing up. Can you state how do you perform the restoration?

Right click SQL Server Agent --> Display error log to see any errors there. Also check the SQL Server errorlog.

Are both servers at same level service pack?

Is your 7.0 database created in multiple file groups? What additional file groups were created during the restoration?

Both backup/restore and sp_detach_db/sp_attach_db work for you to upgrade 7.0 database to...

Create linked server the second server and query the table with four-part qualified name.

select * from tabe1

union all

select * from linkedservername.dbname.dbo.table2

I guess you want to keep both database in synchronization. When you restore PROD to DEV, You should restore both PRDO and PROD1 to development system, Right?

Rename original database name and restore the backup to the original name. In this way, you don't have to change the code to refer to the new restored database.

So the erorr message is kind of miss-leading, isn't it?

Have you reviewed logs created by SQL Server Upgrade Wizard?

I am not aware of it in SQL Server.

If you are running below service pack 3, you can add those users into TargetServerRole role in MSDB.

Service pack 3 makes changes on the permissions to deny TargetServerRole on stored...

quote:

---

I want to set up a job and schedule it to run every day

---

Check...

I would double chcek to ensure both domain service accounts are in the administrators groups in both servers and they are able to access admin shares such as C$, D$...

What type of job it is? Do you create it by using maintenance plan wizard? Please post your SQL Server version and service pack version?

Do you see same slowness by performing file copy?

Go to performance monitor --> Right click counter logs --> New Log setting --> Add counters you want to log --> Schedule Tab --> configure to run at your timeframe.

To...