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 |
|
s2002
Starting Member
49 Posts |
 Posted - 2010-10-24 : 07:10:45
|
| HiI have 1 DB on MSSQL 2005 Enterprise and 1 DB on MSSQL 2008 Enterprise .Both MSSQL servers are located on different hosting companies which only provide me with one DB user accountCould you please tell me how could I copy Structure and All records from MSSQL 2005 to SQL Server 2008. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-24 : 13:32:24
|
Backup/Restore would be the easiest way.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
s2002
Starting Member
49 Posts |
Posted - 2010-10-24 : 23:48:55
|
| Hello webfred,But I can't restore MSSQL 2005 to MSSQL 2008 DB, Since Backup file is not stored locally. Could you please tell me how could I do it? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-25 : 01:18:02
|
My idea was, if you don't have access to the servers, then you could ask the providers.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
s2002
Starting Member
49 Posts |
Posted - 2010-10-25 : 04:06:52
|
| Interesting part is that they don't able to restore it . I think their Server can't restore files bigger than 250MB(my DB size).but I could restore the DB in local SQL server. Is there another way to Restore / Copy DB contents , having only DB Owner privilage. |
|
|
|
|
|
|
SQL 2008 import