Restore to SQL 2005?

Hello,
I'm using SQL 2005 Express and I have a database that I've created a backup
for, but when my ISP tries to restore it with the full version of SQL 2005,
they say the tables are missing. Any ideas why I can restore it with the
Express edition and they can't do it with the full one?
Thanks
Jim
What exactly is meant by "the tables are missing"? Is it that the database
restores successfully but is empty?
On possible cause is that the database backup file contains multiple backups
and only the first (oldest) is restored by default.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jim" <jim@.gordonferon.com> wrote in message
news:%235uFQKUrHHA.3276@.TK2MSFTNGP04.phx.gbl...
> Hello,
> I'm using SQL 2005 Express and I have a database that I've created a
> backup for, but when my ISP tries to restore it with the full version of
> SQL 2005, they say the tables are missing. Any ideas why I can restore it
> with the Express edition and they can't do it with the full one?
> Thanks
> Jim
>
|||Hi Jim
Can you give us more details?
What does 'full version of SQL 2005' mean? Is it standard or enterprise?
32-bit or 64-bit? What OS?
WHO says tables are missing? What tables? Is there an error message? When
does it show up? What does it say exactly?
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Jim" <jim@.gordonferon.com> wrote in message
news:%235uFQKUrHHA.3276@.TK2MSFTNGP04.phx.gbl...
> Hello,
> I'm using SQL 2005 Express and I have a database that I've created a
> backup for, but when my ISP tries to restore it with the full version of
> SQL 2005, they say the tables are missing. Any ideas why I can restore it
> with the Express edition and they can't do it with the full one?
> Thanks
> Jim
>
|||I'm using Visual Web Developer with SQL 2005 Express. I have a database that
I created for my website and everything works the way it should on my
computer. My ISP says the only way they can create the database on their
side is to restore it from a backup. I created a full backup by right
clicking on the database and going through all the steps. When my ISP tries
to restore it, they're telling me that the database is empty. They are using
SQL 2005 Standard version 9.0.3 & my version is 9.00.2047.00. I'm using Win
Xp 32bit. There are no error messages on either my side or their's when
creating or restoring the tables.
Jim
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:OTM%23wWVrHHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi Jim
> Can you give us more details?
> What does 'full version of SQL 2005' mean? Is it standard or enterprise?
> 32-bit or 64-bit? What OS?
> WHO says tables are missing? What tables? Is there an error message? When
> does it show up? What does it say exactly?
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Jim" <jim@.gordonferon.com> wrote in message
> news:%235uFQKUrHHA.3276@.TK2MSFTNGP04.phx.gbl...
>
>
|||Make sure that you backup to a new file (a file which doesn't exist) so you don't by mistake append
the backup and the always restore the most oldest backup. Or check out the INIT option of the backup
command.
Also, don't take your ISP word that the db is empty. Login using a query window (if at all possible)
and verify for yourself. Also, make sure this isn't just a side effect of login - username mismatch
(read about sp_change_users_login and Google for sp_help_revlogins).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jim" <jim@.gordonferon.com> wrote in message news:O4X7j6crHHA.4300@.TK2MSFTNGP05.phx.gbl...
> I'm using Visual Web Developer with SQL 2005 Express. I have a database that I created for my
> website and everything works the way it should on my computer. My ISP says the only way they can
> create the database on their side is to restore it from a backup. I created a full backup by right
> clicking on the database and going through all the steps. When my ISP tries to restore it, they're
> telling me that the database is empty. They are using SQL 2005 Standard version 9.0.3 & my version
> is 9.00.2047.00. I'm using Win Xp 32bit. There are no error messages on either my side or their's
> when creating or restoring the tables.
> Jim
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:OTM%23wWVrHHA.1208@.TK2MSFTNGP02.phx.gbl...
>
>
|||A database can never be completely empty, so this makes me wonder how your
ISP is determining it is 'empty'. My guess is that they are not SQL Server
Professionals, and are jumping to wild conclusions.
Perhaps they are just running sp_help to see a list of objects, or expanding
the tables folder in SSMS Object Explorer, and if they don't have the
appropriate permissions, they will get an empty list.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Jim" <jim@.gordonferon.com> wrote in message
news:O4X7j6crHHA.4300@.TK2MSFTNGP05.phx.gbl...
> I'm using Visual Web Developer with SQL 2005 Express. I have a database
> that I created for my website and everything works the way it should on my
> computer. My ISP says the only way they can create the database on their
> side is to restore it from a backup. I created a full backup by right
> clicking on the database and going through all the steps. When my ISP
> tries to restore it, they're telling me that the database is empty. They
> are using SQL 2005 Standard version 9.0.3 & my version is 9.00.2047.00.
> I'm using Win Xp 32bit. There are no error messages on either my side or
> their's when creating or restoring the tables.
> Jim
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:OTM%23wWVrHHA.1208@.TK2MSFTNGP02.phx.gbl...
>
>
|||Thanks for the suggestions. I ended up copying the data over to tables they
created.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:OmZWtQdrHHA.4828@.TK2MSFTNGP04.phx.gbl...
>A database can never be completely empty, so this makes me wonder how your
>ISP is determining it is 'empty'. My guess is that they are not SQL Server
>Professionals, and are jumping to wild conclusions.
> Perhaps they are just running sp_help to see a list of objects, or
> expanding the tables folder in SSMS Object Explorer, and if they don't
> have the appropriate permissions, they will get an empty list.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Jim" <jim@.gordonferon.com> wrote in message
> news:O4X7j6crHHA.4300@.TK2MSFTNGP05.phx.gbl...
>
>