|
|
Posted by Erland Sommarskog on 09/03/06 09:29
David C. Barber (david@NOSPAMdbarber.com) writes:
> We were upgrading the server hardware for our SQL Server 2000.
>
> We backed up the entire existing server as a full backup.
So you backed all files on the server with Windows backup, and you did not
backup the individual databases through SQL Servers own BACKUP command?
Did you stop SQL Server prior to starting this backup?
> The resulting individual databases, except for the standard ones like
> master that are created by SQL Server itself all restored with several
> dozen blanks appended to the end of the existing database name, which
> appears to break Crystal Reports 10, Access Data Projects, and some VB6
> code, although not the basic connection to the database using VB6.
Could you post the output of this query:
SELECT len(name), datalength(name)/2, name
FROM master..sysdatabases
ORDER BY name
Is the old hardware available, so you can start it, and run the same
query there?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|