sql server new users: backup restored to other machine is missing stored proc and functions -- sql server new users

backup restored to other machine is missing stored proc and functions

keithb
4/18/2006 8:41:39 AM

sql server new users: I made a backup of my sql server 2000 database and restored it to sql server
2000 on another machine. Checking the restored database, several of my most
recently created stored procedures and functions were not there. What causes
this, and how can I make sure that the most recent version of my data is
restored?

Also, could I accomplish moving the data by simply copying the .mdf file and
restoring in on the other server?

Thanks,

Keith

Re: backup restored to other machine is missing stored proc and functions

Tom Moreau
4/18/2006 11:49:33 AM

Check out sp_change_users_login in the BOL. If you have objects that aren't
owned by the dbo, that could be the problem.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
I made a backup of my sql server 2000 database and restored it to sql server
2000 on another machine. Checking the restored database, several of my most
recently created stored procedures and functions were not there. What causes
this, and how can I make sure that the most recent version of my data is
restored?

Also, could I accomplish moving the data by simply copying the .mdf file and
restoring in on the other server?

Thanks,

Keith