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.
| Author |
Topic |
|
slimjen
Yak Posting Veteran
61 Posts |
 Posted - 2007-03-26 : 20:36:46
|
| I used backup and restore to upgrade to sql 2005 from 2000. It went well but I didn't get the permissions change in time for the users to access the database today. The users were accessing the old server. I need to do another backup off the old server to the new server. Do I do a full backup to get the information for today's data or what? Will it restore a full backup override? |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-27 : 00:22:30
|
| Once the databases are recovery you can't copy the one day data easily...so run the full backup and restore on to new server which will overwrite everything....You need to copy the logins too...Check the following article...How to transfer logins and passwords between instances of SQL Serverhttp://support.microsoft.com/kb/246133MohammedU |
 |
|
|
|
|
|
backup and restoring after upgrade