Viewing 15 posts - 406 through 420 (of 1,524 total)
I ran the CHECK INTEGRITY on the db on the other SQL Server and there IS corruption.... so much that I didn't cut/paste it all into this thread.....
Msg 8929, Level...
August 2, 2014 at 4:47 am
Update. I was able to get a new large drive allocated to another server running SQL2008R2 and I copied the 140gig db backup to it and it successfully restored...
August 1, 2014 at 4:42 pm
GilaMonster (8/1/2014)
That looks like IO subsystem, the page headers are invalid, not something an import could do. Doesn't have to be the drives, could be anything in the IO stack.
Yikes......
August 1, 2014 at 7:23 am
Well... the plot thickens.... This morning I ran a Check integrity on the newly created database with more than half of the tables in it populated..... I have...
August 1, 2014 at 7:16 am
SQLRNNR (7/31/2014)
How much freespace are you dealing with? How much freespace on the volume that houses tempdb?
187 Gig of free space on the drive.
July 31, 2014 at 2:18 pm
Nothing about this db is easy... the import failed and when i tried to save the file that shows the error the Import/Export wizard got an error and closed.
Then I...
July 31, 2014 at 2:11 pm
Gazareth (7/31/2014)
Markus (7/31/2014)
SQLRNNR (7/31/2014)
I'll try to think on it some more. I'm sure this odd error has you frustrated.
Yes. I've never seen anything like this before. It...
July 31, 2014 at 8:52 am
SQLRNNR (7/31/2014)
I'll try to think on it some more. I'm sure this odd error has you frustrated.
Yes. I've never seen anything like this before. It does smell...
July 31, 2014 at 8:43 am
SQLRNNR (7/31/2014)
Is the backend device attached...
July 31, 2014 at 8:34 am
Can't do that. Reason being is the database is just over 800 GIG and I don't have another SQL2008R2 with that much space available to restore it to.
Right now...
July 31, 2014 at 7:07 am
SQLRNNR (7/30/2014)
So restore database with backup on NAS = fail
Restore database with backup on backend storage = fail
Restore database from vendor backup = fail
Restore database from newly created backup after...
July 31, 2014 at 5:57 am
SQLRNNR (7/30/2014)
Is this thread of any help?http://www.sqlservercentral.com/Forums/Topic1279635-266-1.aspx
Yes I saw this post before I started mine. Not of any help.
July 30, 2014 at 9:47 am
The restore does start and it does create all of the files on the initialization of the backup. At about 20% into the restore it fails with the message...
July 30, 2014 at 9:17 am
SQLRNNR (7/30/2014)
Markus (7/30/2014)
SQLRNNR (7/30/2014)
Markus (7/30/2014)
SQLRNNR (7/30/2014)
Markus (7/30/2014)
SQLRNNR (7/30/2014)
July 30, 2014 at 9:03 am
SQLRNNR (7/30/2014)
Markus (7/30/2014)
SQLRNNR (7/30/2014)
Markus (7/30/2014)
SQLRNNR (7/30/2014)
July 30, 2014 at 7:58 am
Viewing 15 posts - 406 through 420 (of 1,524 total)