cords into new table on new server.
System said that new table was created successfully and all records were cop
ied.
We decided to backup this new database, but it failed. Investigating of back
up problem led us to the point where we realised that our actuall database b
ecome 2 times larger - 150GB insted of 75 (original size).
Kind of lost where this additional chunk came from.
Will be thankful for any suggestions,
Alan.Alan,
Did you create new database with the same data device and log device as the
original one?
Did you try to shrink the data files using DBCC?
larry
"ALan" <anonymous@.discussions.microsoft.com> wrote in message
news:49C0FD90-FFFA-4CE5-B8F8-0A43E1E8B22D@.microsoft.com...
quote:
> We had to move exsiting database on new server and ran querey copying all
records into new table on new server.
quote:
> System said that new table was created successfully and all records were
copied.
quote:
> We decided to backup this new database, but it failed. Investigating of
backup problem led us to the point where we realised that our actuall
database become 2 times larger - 150GB insted of 75 (original size).
quote:
> Kind of lost where this additional chunk came from.
> Will be thankful for any suggestions,
> Alan.
No comments:
Post a Comment