Viewing 15 posts - 271 through 285 (of 469 total)
Well, if not the DB backup..there should be tape backups of the drives on which these files were placed.. I restored one of my MDF files from the tape which...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 31, 2008 at 11:01 am
Rolling upgrade is not supported for SP2.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 31, 2008 at 9:25 am
Follow the link for a detailed installation guide...also be advised that it requires a reboot...
http://support.microsoft.com/default.aspx?scid=kb;en-us;328839
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 31, 2008 at 9:14 am
[font="Comic Sans MS"]
...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 31, 2008 at 9:05 am
DBCC Checkident corrected the seed value on both test and the actual db..thanks a lot Gail..
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 31, 2008 at 6:43 am
The primary key is on the Identity..which I am not referencing while doing the insert.
How do I reseed this field..if so will it fix the problem with the insert?
Thanks Again!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 30, 2008 at 2:45 pm
Don't now why I get this error when I try to do an insert on the table after the repair was run. The table has an identity key.
insert into tblTransactionResponse...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 30, 2008 at 2:31 pm
I will wait until Jan 5th probably..as I dont see any other options either. I have attached the detailed logs after running various commands. I ran these CheckDb commands by...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 30, 2008 at 2:03 pm
I am posting the detailed error report.
When I run select * on the table I get the error as
Server: Msg 7105, Level 22, State 6, Line 1
Page (1:75439), slot 12...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 30, 2008 at 1:04 pm
I support kandal.vandyke's purpose of starting this post as I am curious to know the detailed technical difference between the two RAID's..but would like to throw some stuff from...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 28, 2008 at 1:27 pm
sayfrend (12/23/2008)
Steve Jones - Editor (12/23/2008)
Thats what makes you an editor of forum like SQL Server Central. You are Simple Best !!!
I Want to have as much knowledge as...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 23, 2008 at 6:04 pm
Paresh Prajapati (12/22/2008)
You can setup Replication ,Mirroring or Log Shipping in this case.
The Dev or UAT server needs to be in available state during and after the refresh process...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 23, 2008 at 8:21 am
I guess I am referring to the literal meaning..like database not in suspect state or offline...as long as it is not in these states I would be fine saying the...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 23, 2008 at 8:05 am
Make sure you backup prod and dev/UAT before you drop of create anything..as it is the first time you are doing it better be safe than be sorry...Good Luck!!
Thanks!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 23, 2008 at 7:53 am
looks like sql 7 doesn't support device backups..i tried time and again but its copying only to a single file. I believe i ll have to have a dedicated disk...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 19, 2008 at 5:30 pm
Viewing 15 posts - 271 through 285 (of 469 total)