The "Hot Summer is already nearing an end" August BS Thread
#905
08-15-2012, 07:55 AM
Posting Guru
Join Date: Jul 2010
Location: Out of Bounds
Posts: 1,052
Likes: 0
Received 0 Likes
on
0 Posts
#907
08-15-2012, 07:59 AM
Posting Guru
Join Date: Jul 2010
Location: Out of Bounds
Posts: 1,052
Likes: 0
Received 0 Likes
on
0 Posts
#909
08-15-2012, 08:18 AM
Postmaster
Join Date: Jun 2011
Location: On the saddle
Posts: 3,293
Likes: 0
Received 0 Likes
on
0 Posts
#910
08-15-2012, 08:29 AM
#912
08-15-2012, 08:41 AM
In Recovery... | TechEd demo: corruptions fatal to DBCC CHECKDB
"
The aim of this demo is to show that sometimes a database is so corrupt that DBCC CHECKDB just cannot run on it. In that case, there's no way to force DBCC CHECKDB to get past the fatal corruption and so there's no way to run a repair either - you're looking at restoring from a backup or at worst, extracting as much data as possible into a new database. "
Ugh.
Do you have any RedGate products? If so, I'd consider setting up a new database (from backup, if exists) and then migrating all the current data into it.
"
The aim of this demo is to show that sometimes a database is so corrupt that DBCC CHECKDB just cannot run on it. In that case, there's no way to force DBCC CHECKDB to get past the fatal corruption and so there's no way to run a repair either - you're looking at restoring from a backup or at worst, extracting as much data as possible into a new database. "
Ugh.
Do you have any RedGate products? If so, I'd consider setting up a new database (from backup, if exists) and then migrating all the current data into it.
SQL Express does not have the agent to make backups easy. After enough trial and error I have a batch file which will call a SQL query to backup the database and name it with the date. I can run this every night.
As to the database I was having problems with, I think I got it licked. I ended up creating a new database and then using
Code:
INSERT INTO DestinationDB..DestinationTable SELECT * FROM SourceDB..SourceTable
I'm sure a SQL DBA would be laughing his *** off at me but then again, I would be laughing my *** off at them trying to figure out the hardware side of this stuff.
#913
08-15-2012, 09:10 AM
Fleet Owner
I would be set if I had a backup.
SQL Express does not have the agent to make backups easy. After enough trial and error I have a batch file which will call a SQL query to backup the database and name it with the date. I can run this every night.
As to the database I was having problems with, I think I got it licked. I ended up creating a new database and then using
The important data that I needed was still there so I copied the data from the select tables that were important and now we will see if it works. I'll be heading down there either this afternoon or tomorrow morning to set up the new database.
I'm sure a SQL DBA would be laughing his *** off at me but then again, I would be laughing my *** off at them trying to figure out the hardware side of this stuff.
SQL Express does not have the agent to make backups easy. After enough trial and error I have a batch file which will call a SQL query to backup the database and name it with the date. I can run this every night.
As to the database I was having problems with, I think I got it licked. I ended up creating a new database and then using
Code:
INSERT INTO DestinationDB..DestinationTable SELECT * FROM SourceDB..SourceTable
I'm sure a SQL DBA would be laughing his *** off at me but then again, I would be laughing my *** off at them trying to figure out the hardware side of this stuff.
Good morning Chris. You going to be at the gtg this weekend?
#914
08-15-2012, 09:10 AM
Posting Guru
Join Date: Jul 2010
Location: Out of Bounds
Posts: 1,052
Likes: 0
Received 0 Likes
on
0 Posts
#915
08-15-2012, 09:12 AM
Join Date: Apr 2004
Location: Big Lake, MN
Posts: 2,295
Likes: 0
Received 0 Likes
on
0 Posts
I would be set if I had a backup.
SQL Express does not have the agent to make backups easy. After enough trial and error I have a batch file which will call a SQL query to backup the database and name it with the date. I can run this every night.
As to the database I was having problems with, I think I got it licked. I ended up creating a new database and then using
The important data that I needed was still there so I copied the data from the select tables that were important and now we will see if it works. I'll be heading down there either this afternoon or tomorrow morning to set up the new database.
I'm sure a SQL DBA would be laughing his *** off at me but then again, I would be laughing my *** off at them trying to figure out the hardware side of this stuff.
SQL Express does not have the agent to make backups easy. After enough trial and error I have a batch file which will call a SQL query to backup the database and name it with the date. I can run this every night.
As to the database I was having problems with, I think I got it licked. I ended up creating a new database and then using
Code:
INSERT INTO DestinationDB..DestinationTable SELECT * FROM SourceDB..SourceTable
I'm sure a SQL DBA would be laughing his *** off at me but then again, I would be laughing my *** off at them trying to figure out the hardware side of this stuff.
Ya, what you said!
