Viewing 15 posts - 2,446 through 2,460 (of 3,060 total)
Henry Lee (7/24/2009)
Similarly, there will be some that can not be down for...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 24, 2009 at 7:19 am
I personaly like the "business continuity" wording more rather than "disaster recovery".
So you have anything in between two hundred to a dozen hundred databases?
First question would be... do all these...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 24, 2009 at 6:33 am
Senthil Kumar Rajendran (7/22/2009)
I want to import Oracle Database into SQL Server 2005 Using Import Export wizard. Can any body suggest me how can i do this...
Question... do you intend...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 23, 2009 at 2:36 pm
I would respectfully disagree.
If I got it right PreferenceType is an attribute of Territory being "Territory" the entity described by Territories table.
Having said that some territories would have PreferenceType =...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 22, 2009 at 12:21 pm
Firstly, I'm in agreement about relying in OPENQUERY.
Secondly, check query plan on Oracle side.
Run an explain plan for the offending query, it will tell you if Oracle -not SQL Server...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 21, 2009 at 5:24 am
Jeffrey Williams (7/20/2009)MERGE is not available in SQL Server 2005 - it was introduced in SQL Server 2008.
I stand corrected. Thank you Jeff.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2009 at 3:56 pm
Slick84 (7/20/2009)
Would the inserts go first or the updates?
Two questions...
1- Are we talking about a small OLTP alike transaction OR are we talking about a large ETL alike transaction?
2- If...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 20, 2009 at 3:34 pm
Maksuda... something does not adds up.
I understand model database was set to read-only mode, is that correct?
I understand tlog for model database keeps growing, is that correct?
If answers are Yes...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 2:24 pm
mmmhhh... wouldn't help to include % signs in "like" predicate option?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 1:36 pm
Does the target server allows remote connections?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 11:55 am
vkundar (7/17/2009)
I have accidently droped a Database and dont have a backup.
Boomer. Hopefully you have learned a lesson as a result of such an unfortunate chain of events.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 11:47 am
h_maksuda (7/17/2009)I stopped backup process three days before,if any backdoor backup is happening I don't know. But from my side no backup is running(I'm worried without backup).
mmhhh... may be...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 9:00 am
Being a dev environment I would follow Jason's suggestion... set model database to read-only, sit down and wait from somebody to come to your office and complain.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 8:55 am
Grant Fritchey (7/17/2009)
Just be utterly paranoid.
Paranoid is what keeps databases available, recoverable and performing beyond SLA 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 7:27 am
dba-vb (7/17/2009)
we are moving our production databases to another machine(server). what should i take care(from the sqlserver side)?
Do it twice, a test run then a go-live one.
During the test run...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 17, 2009 at 7:14 am
Viewing 15 posts - 2,446 through 2,460 (of 3,060 total)