Viewing 15 posts - 3,016 through 3,030 (of 3,060 total)
correct... correct... incorrect.
damn, you failed in the last one. You can take backups using RMAN even if you have set your database to NOARCHIVELOG mode. That's the beauty of...
_____________________________________
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.August 8, 2008 at 9:44 am
... like Oracle's inbuilt primary key ROWID
Oracle's ROWID is not a PK. ROWID is a unique row identifier, nothing else, nothing more.
_____________________________________
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.August 8, 2008 at 9:41 am
The DTS which was part of SQL Server 2000...
DTS was introduced on 7.0
_____________________________________
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.August 7, 2008 at 1:47 am
I'm glad you fixed it.
Just a side note. The fact that you rebuild your indexes in a weekly basis means nothing, how if you are rebuilding once and again indexes...
_____________________________________
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.August 7, 2008 at 1:45 am
You may want to start here... http://msdn.microsoft.com/en-us/library/ms190768.aspx 😉
_____________________________________
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.August 6, 2008 at 7:40 am
Maybe it's 400TB because no-one has been running T-Log backups, they just added more disk space, the data could be just a few GB ?!?!? :hehe:
😀 You made may day....
_____________________________________
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.August 6, 2008 at 7:37 am
I see, you are affected by CAS -short for Crappy Application Syndrome.
CAS is a serious condition the only cure is major surgery -kill the CAS causing agent but in some...
_____________________________________
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.August 6, 2008 at 5:52 am
Dear Ehsan --
Firstly I'm not saying I know everything. I'm saying I know what a Oracle backup is and what a Oracle backup is not.
Secondly. You are correct, I was...
_____________________________________
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.August 6, 2008 at 5:34 am
Here is what I would do...
1- RDC into the remote box.
2- Open SSMS and open the local server
3- Run select @@servername to get the actual instance name.
4- Check error log,...
_____________________________________
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.August 6, 2008 at 4:44 am
Any reason why you don't do something like...
UPDATE intv_schedule
SET program_id = (
...
_____________________________________
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.August 6, 2008 at 4:23 am
Gotcha, your "clients" are actual SQL Server engines.
-Can you ping the remote box by DNS?
-Can you ping the remote box by IP?
-Does the remote "client" SQL Server engine has a...
_____________________________________
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.August 6, 2008 at 3:54 am
Let me summarize your "concepts"...
Exp/Imp based backup strategy?
Daily Cold Backup?
Daily Cold/Hot Backup followed by full Export?
Full Database Reorg?
At first sight I would say -very politely: "what a pile of crap!!!"......
_____________________________________
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.August 6, 2008 at 3:43 am
Not sure if I follow you.
Is your problem that you are unable to access a client station from the server?
If this is the case... are you actually talking about...
_____________________________________
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.August 6, 2008 at 3:31 am
Yes, I have a doubt.
Other that what's the reason you guys do not read what I write... my doubt is: what a big pile of rubbish!!! from which paralell Universe...
_____________________________________
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.August 6, 2008 at 2:00 am
Support Gints.
By the way, you do not "convert" storedprocs from SQL Server to Oracle, you learn what the storedproc is supposed to do and you rewrite it from scratch.
The...
_____________________________________
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.August 6, 2008 at 1:30 am
Viewing 15 posts - 3,016 through 3,030 (of 3,060 total)