| Author |
Topic |
|
warbirdcolors
Starting Member
5 Posts |
 Posted - 2011-01-19 : 20:57:00
|
| I'm moving a web-site & database to a new webserver/hosting company. I backed up the database and then restored the SQL database to the new web server, but all of my stored procedures are gone?? How can I restore them? Did I save the database incorrectly? How do I bring across the stored procedures without having to re-key them all??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
warbirdcolors
Starting Member
5 Posts |
Posted - 2011-01-20 : 00:32:25
|
| To my knowledge, this is what i did:I did a save of the database, and then moved the .bak file to my hard drive. I uploaded that .bak file to the new server, and did a restore...to a differently named database. this is going from a newer database, to an older database |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-01-20 : 01:05:05
|
where did you "saved" your stored procedure ? Any chance you did it in the master database ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-20 : 16:25:08
|
quote:
Originally posted by warbirdcolors
To my knowledge, this is what i did:I did a save of the database, and then moved the .bak file to my hard drive. I uploaded that .bak file to the new server, and did a restore...to a differently named database. this is going from a newer database, to an older database
Can you clarify what you mean by this? You cannot restore a database that was backed up on a new version to an older version. For example, if the system you are running is 2008 - you cannot restore that backup to a 2005 system.Are you sure you copied a current version of the backup file and restored from the same backup file?Jeff |
|
|
|
warbirdcolors
Starting Member
5 Posts |
Posted - 2011-01-20 : 19:35:21
|
| When i right-click the server(s) in SQL Server Management Studio, and select properties this is what i see:The "from" database is version 10.0.4000.0The "to" database is version 9.00.4309.0I can see my tables and my data in the "new" database |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
warbirdcolors
Starting Member
5 Posts |
Posted - 2011-01-20 : 19:41:39
|
| Tara,First of all..Thanks for your helpI used the backup function within the management studio, FTP'd the .bak file to the new hosting server at godaddy.com and used their "restore" button and pointed to the .bak fileIs there a way i can "start over" to do this a different way? I know you don't see the godaddy stuff so...could it have "copied" the database from the .bak file? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
warbirdcolors
Starting Member
5 Posts |
Posted - 2011-01-20 : 19:54:55
|
| OK, so i script each one to it's own file? and on the other end I choose New stored procedure & copy/paste? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-21 : 15:10:37
|
| Instead of trying to back port everything you have developed and worked on in SQL Server 2008, why don't you have godaddy.com provide you with a 2008 instance (10.0.4000) instead of SQL Server 2005 (9.00.4309.0)?Then, you can just do a backup/restore to get everything updated.Besides, if you do your development work on 2008 - you have to be very careful not to use any of the 2008 specific features and data types or they will not work.Jeff |
|
|
|
|
stored procedures