Backup Compatibility?

I've heard that backups are compatible across all versions of SQL Server
2005, but haven't yet found this in print from MS.
Does anyone know of a link or document to verify or refute this?
TIA,
dj"dj" <dj@.discussions.microsoft.com> wrote in message
news:6FD19460-C578-4AD3-8555-2B5E1B337976@.microsoft.com...
> I've heard that backups are compatible across all versions of SQL Server
> 2005, but haven't yet found this in print from MS.
> Does anyone know of a link or document to verify or refute this?
>
If you mean within 2005 yes. Can I find a document, no but consider the
engine is the same across all, just with different options, I can't imagine
it would be any other way.
Having said that, because of ENGINE differences, you may have issues. I
doubt you could restore a database larger than 4 gig to an Express edition
since express can't run it.

> TIA,
> dj|||"dj" <dj@.discussions.microsoft.com> wrote in message
news:6FD19460-C578-4AD3-8555-2B5E1B337976@.microsoft.com...
> I've heard that backups are compatible across all versions of SQL Server
> 2005, but haven't yet found this in print from MS.
> Does anyone know of a link or document to verify or refute this?
>
If you mean within 2005 yes. Can I find a document, no but consider the
engine is the same across all, just with different options, I can't imagine
it would be any other way.
Having said that, because of ENGINE differences, you may have issues. I
doubt you could restore a database larger than 4 gig to an Express edition
since express can't run it.

> TIA,
> dj

Backup Compatibility?

I've heard that backups are compatible across all versions of SQL Server
2005, but haven't yet found this in print from MS.
Does anyone know of a link or document to verify or refute this?
TIA,
dj"dj" <dj@.discussions.microsoft.com> wrote in message
news:6FD19460-C578-4AD3-8555-2B5E1B337976@.microsoft.com...
> I've heard that backups are compatible across all versions of SQL Server
> 2005, but haven't yet found this in print from MS.
> Does anyone know of a link or document to verify or refute this?
>
If you mean within 2005 yes. Can I find a document, no but consider the
engine is the same across all, just with different options, I can't imagine
it would be any other way.
Having said that, because of ENGINE differences, you may have issues. I
doubt you could restore a database larger than 4 gig to an Express edition
since express can't run it.
> TIA,
> dj

Backup a single table?

In SQL 6.5 you could backup a single table in a db to a
backupdevice or a file. I can not find this in the newer
versions SQL 7.0 and SQL 2000. Is this feature removed?
I know that the command has changed from DUMP to BACKUP
and that you nowadays often backup db-files or filegroups
instead.This feature has been removed with SQL2000
"Stefan" <stefan@.discussions.microsoft.com> wrote in message
news:033c01c4b815$4a8a0600$a601280a@.phx.gbl...
> In SQL 6.5 you could backup a single table in a db to a
> backupdevice or a file. I can not find this in the newer
> versions SQL 7.0 and SQL 2000. Is this feature removed?
> I know that the command has changed from DUMP to BACKUP
> and that you nowadays often backup db-files or filegroups
> instead.
>|||> I know that the command has changed from DUMP to BACKUP
> and that you nowadays often backup db-files or filegroups
> instead.
You will have to either (a) put it onto its own filegroup and backup the
filegroup, or (b) DTS a copy into an empty database and backup that
database.
--
http://www.aspfaq.com/
(Reverse address to reply.)