DBCC CHECKDB: admin

Showing posts with label admin. Show all posts

Thursday, March 29, 2012

DBA Contract without Local Admin priveleges

O what a place to be

I started this Contract as an (Interim) for a new DBA role, for an application support Company last month & all was going well.

The User Application is run via Citrix against multiple Hosted Sybase ASA Databases.

I introduced SQL 2005 with Reporting Services as a mixed Data Mart Remote Query via ODBC Linked Servers setup.

Because they had never had a DBA before the Data I was able to pull from over thirty seperate databases into one and present via Reporting Services has blown them away.

And then one day the Senior Support Analyst told me he had put the main most important Sybase Database on a completely seperate domain he had created(with no Trust between the two) , because he was unable to secure the existing domain against unauhorized remote internet intrusion & Viruses.

(I never liked the idea that hosted customers were domain\users on the Corporate network)

To add insult to injury he then told me to install & maintain another SQL Box on the new domain, OK so far.

I logged into the supoposed new box via citrix & then remote desktop, and to my disbelief he had the desktop locked down - no access to control panel or anything - he asked me why i needed access - I told him - he asked me why I need to have reboot priveleges - I told him.

So now he's installed 2005 himself in the vain hope I can work without Local Admin privelages or need to unlock the Desktop - he certainly won't give me Domain Admin.

I Just cannot believe I'm unable to persuade him to Unlock the Desktop & have even threatened to walk out unless he lets me do my Job.

He probably does'nt like me but there can be absolutely no question about my abilities or accessing data that i should'nt.

He's basically read a Deny by Default article and expects me to start of as a user with a locked desktop and then request & justify escalating my security from there.

Is this possible ?

Good Grief :eek: Any ideas what I should do ?

Thanks

GW& have even threatened to walk out unless he lets me do my Job.

I say do that! :p

Or tell him that if the server needs a reboot then he has to do it - point out to him that if the server goes down (day or night) he will have to remote connect to work and sort it out - rather than having one of his capable "drones" doing it. Tell him to expect to be on-call 24/7/365 (that is assuming that he wants his customers server to be online 99.9% of the time)

If he's so uppity about security then maybe you should suggest signing some disclaimer saying that you're not going to prat about with the server or any sensitive data in contains?

You can't do your job without the access, period.

Alternatively, simply tell him to "[expletive] off" when he asks you anything about that server :D|||I would just pester him with emails (cc'd to appropriate folks) that you need various tasks done on the server. Be good and vague about the actual details. For example: "Please be sure that daily backups are taken of these databases." If he is worth dealing with, he will figure out SQL Agent quickly enough. If not, well, just sit back and laugh as he does the backups manually. Escalate as necessary (Make sure the backups are not on the same physical disk as the database).

Once he has all that squared away, if you are not satisfied, hit him up with profiler trace requests. This should be accompanied by a stream of SQL scripts that are "tweaks to existing code".

Polish the whole thing off with requests to load data from various sources (implementation details left to him, of course).

And of course, most importantly, sprinkle liberally with thanks, and politeness.|||Ahh, the old scaremongering tactics - hadn't even crossed my mind!|||Who is your manager? They should be fighting this battle with/for you. If you where hired to do a job and are unable to it will reflect badly on the whole chain.

Alternatively I think goergev's first approach is best. Getting into a p_ssing contest with a Senior employee when you are new is not a wise path.

Changing culture is never an easy task. Good luck.|||MMMmmmmm tehe - U Monkeys !!

Such a shame though this is going to slow my dev progress to a crawl & I take pride in my work.

I'm happy as a contractor and would'nt take a permie role anyway - hope the new DBA likes his new life.

I just wonder how he's (Senior Support Analyst) gonna secure his brave new world when he's not capable of purging the existing one.

Dunno loads about Citrix & Network Security best practices but Is it common to let Customers on to the Corporate Domain as Users, Is Citrix really that secure ?.

I figure he's set himself up as Domain Admins and does'nt want to share his power with the rest of IT.

GW|||I figure he's set himself up as Domain Admins and does'nt want to share his power with the rest of IT.
bingo! :)

If he's willing to take all the power, then he's gotta be willing to take all the responsibility that comes with it too.|||Sorry, I mis-understood your message of "interim for a New DBA role". I saw that as "contract for hire".

I am a contractor too so I understand the "no permies" feeling. But I will ask you the question. What were you hired to do? Write reports or prepare the way for a new DBA or both. Since you are a contractor you can be even bolder in dealing with culture. Tell them there is a helpful way and a non-helpful way to do things. Right now he, and by extension the company, is in a non-helpful mode.

As a contractor I would much rather come into a company where the previous contractors where helpful themselves because it makes my experience better.|||Sorry Bartron Maybe I was'nt quite Clear.

The company had never had a DBA before - they hired one but had to wait 3 Months for him to start - Thus I got the contract for 3 months to fill in.

(they have a 5 strong IT Application Support Dept with strong links to the Application Developers in the holding company)

The new DBA has since turned down the job & the Co. are now actively seeking someone else.

My Brief was simple "Consider us a Greenfield site and start from scratch doing what you think is Best - we need reports on all these seperate Sybase databases".

So I recommended and implemented a SQL 2005 Data Mart with reporting Services.

GW|||Sounds like a great approach to their original intent.

Good luck dealing with the new agenda. :-) Seems like "doing what you think is best" should give you some leverage. Of course they can always ignore it. Their peril.|||... expects me to start of as a user with a locked desktop and then request & justify escalating my security from there.

Seems pretty standard at face-value. I'm don't need domain or local admin on any of our production sql server boxes to do my job. It would help and it sure would be nice, but I don't need it. On the same token, our network engineers understand and take on responsibility for the server itself. This includes restarting it on my request, staying current with patches and feeding me requested wmi indicators.

The problem arises when someone is locking you down just because they can. If they still give you grief after you have clearly justified your requirements, take it to your contract admin and draw a picture for them of how this person is directly hindering your ability to perform.|||Thanks to everyone for your support.

Looks like I'm just gonna have to leave em with a less developed and less stable product.

Thanks Teddy for clarifying it is possible to be a DBA without Local Administrator security.
(Do they allow you to access the control panel or event logs ?)

Just seems ridiculous to me considering I'm the only DBA here & I recommended, designed & wrote the Bl**dy thing.

It's not even an OLTP it's a sodding homemade Data Mart.

The only thing on this new network for the next few months is one of the 30 Sybase DB's - I have Domain Admins to the current network.

:eek: A Contractors Life is not an easy one.

GW|||Thanks Teddy for clarifying it is possible to be a DBA without Local Administrator security.
(Do they allow you to access the control panel or event logs ?)

No, yes.

I'm in a highly responsive environment though so this works fine. If I OMGJUSTNEED to perform administrative tasks, I can tap an engineer and either guide them or have them over my shoulder as I do whatever it is I need to do. I get whatever general filesystem access I request and I can requisition whatever additional logging I need including exposing log files, setting up wmi logging or asking for a new package to be designed for one of our third-party performance monitoring applications.

If engineering wasn't as responsive as they are, I would be able to justify administrative rights on our servers. If you're in one of those "job security through obscurity" environments where one person is guarding the keys to the proverbial kingdom with their life, then you might want to go ahead and push for those admin rights.

DBA Administration db

HI, I would like to set up a dba admin database on each of the instances that I have. Is there any recommended standard format for this database?

Thanks

It would be totally dependent upon how you plan to use it. There are just too many variables.

DBA Administration db

HI, I would like to set up a dba admin database on each of the instances that I have. Is there any recommended standard format for this database?

Thanks

It would be totally dependent upon how you plan to use it. There are just too many variables.

DBA Admin

Folks,
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what types
of roles i can pass to them.
TIAThis is a multi-part message in MIME format.
--020005080903090402010906
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
This is a document that Microsoft put together some time ago but is
still a good best-practices reference. The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations, design/planning,
etc. You can find it here:
http://www.microsoft.com/technet/prodtechnol/sql/default.mspx
All that documentation should keep you reading until you're ready to retire.
HTH
--
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
rupart wrote:
>Folks,
>I am a new DBA in my co. I would like to have a good practices on how to
>really keep track and maintain the dbs that we have. We have a lot of dbs
>around the co.
>Best practices, tips to how effeciently manage the dbs would be a great
>start for me. we also do have phone call support here and i wonder what types
>of roles i can pass to them.
>TIA
>
--020005080903090402010906
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>SQL Server 2000 Operations Guide 
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx</a> ">http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx">http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx</a> 
 
This is a document that Microsoft put together some time ago but is
still a good best-practices reference.Â The part of Microsoft's TechNet
website they've dubbed Microsoft SQL Server TechCenter is also a good
source of information around tips & tricks, operations,
design/planning, etc.Â You can find it here: 
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/technet/prodtechnol/sql/default.mspx</a> ">http://www.microsoft.com/technet/prodtechnol/sql/default.mspx">http://www.microsoft.com/technet/prodtechnol/sql/default.mspx</a> 
 
All that documentation should keep you reading until you're ready to
retire. 
 
HTH 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson 
 mallesons stephen jaques 
blog: <a href="http://links.10026.com/?link=/">http://sqlnerd.blogspot.com">
http://sqlnerd.blogspot.com</a> 
</div>
 
 
rupart wrote:
<blockquote cite="midE7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com"
type="cite">
<pre wrap="">Folks,
I am a new DBA in my co. I would like to have a good practices on how to
really keep track and maintain the dbs that we have. We have a lot of dbs
around the co.
Best practices, tips to how effeciently manage the dbs would be a great
start for me. we also do have phone call support here and i wonder what types
of roles i can pass to them.
TIA
</pre>
</blockquote>
</body>
</html>
--020005080903090402010906--|||rupart
I prefer
<http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
> --administaiting best practices
<http://vyaskn.tripod.com/sql_server_security_best_practices.htm> --se
curity best practices
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> Folks,
> I am a new DBA in my co. I would like to have a good practices on how to
> really keep track and maintain the dbs that we have. We have a lot of dbs
> around the co.
> Best practices, tips to how effeciently manage the dbs would be a great
> start for me. we also do have phone call support here and i wonder what
types
> of roles i can pass to them.
> TIA|||thx for all the tips...will start reading
"Uri Dimant" wrote:
> rupart
> I prefer
> <http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
> > --administaiting best practices
> <http://vyaskn.tripod.com/sql_server_security_best_practices.htm> --se
> curity best practices
>
>
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:E7D2A204-7587-4226-B454-206E4E7C301C@.microsoft.com...
> > Folks,
> > I am a new DBA in my co. I would like to have a good practices on how to
> > really keep track and maintain the dbs that we have. We have a lot of dbs
> > around the co.
> > Best practices, tips to how effeciently manage the dbs would be a great
> > start for me. we also do have phone call support here and i wonder what
> types
> > of roles i can pass to them.
> >
> > TIA
>
>

DBA Admin

Wednesday, March 21, 2012

db seperation

I was given a task of doing the following and I'm not 100% sure what the
manager means. I'm not a database admin at all so I'm totaly new to all of
this. The manager wants me to seperate the transactional database from the
backend database.
What does that mean exactly? Can anyone provide me any information on what
exactly is and how to go about designing it then putting it into a working
mode?
thanks
Thanks, I'm in that process now actually to get more details on what she
actually wants done with the databases.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O6SNFx3rHHA.4180@.TK2MSFTNGP04.phx.gbl...
> He might mean that the 2 databases are 'transactional' and 'reporting/BI'
> and should go on different servers, but who knows? We can help with
> technical details but you'll need to clarify the requirements fully with
> the manager first otherwise it's guesswork...
> Cheers,
> Paul Ibison
>

db seperation

I was given a task of doing the following and I'm not 100% sure what the
manager means. I'm not a database admin at all so I'm totaly new to all of
this. The manager wants me to seperate the transactional database from the
backend database.
What does that mean exactly? Can anyone provide me any information on what
exactly is and how to go about designing it then putting it into a working
mode?
thanksHe might mean that the 2 databases are 'transactional' and 'reporting/BI'
and should go on different servers, but who knows? We can help with
technical details but you'll need to clarify the requirements fully with the
manager first otherwise it's guesswork...
Cheers,
Paul Ibison|||Thanks, I'm in that process now actually to get more details on what she
actually wants done with the databases.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O6SNFx3rHHA.4180@.TK2MSFTNGP04.phx.gbl...
> He might mean that the 2 databases are 'transactional' and 'reporting/BI'
> and should go on different servers, but who knows? We can help with
> technical details but you'll need to clarify the requirements fully with
> the manager first otherwise it's guesswork...
> Cheers,
> Paul Ibison
>

db seperation

I was given a task of doing the following and I'm not 100% sure what the
manager means. I'm not a database admin at all so I'm totaly new to all of
this. The manager wants me to seperate the transactional database from the
backend database.
What does that mean exactly? Can anyone provide me any information on what
exactly is and how to go about designing it then putting it into a working
mode?
thanksHe might mean that the 2 databases are 'transactional' and 'reporting/BI'
and should go on different servers, but who knows? We can help with
technical details but you'll need to clarify the requirements fully with the
manager first otherwise it's guesswork...
Cheers,
Paul Ibison|||Thanks, I'm in that process now actually to get more details on what she
actually wants done with the databases.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O6SNFx3rHHA.4180@.TK2MSFTNGP04.phx.gbl...
> He might mean that the 2 databases are 'transactional' and 'reporting/BI'
> and should go on different servers, but who knows? We can help with
> technical details but you'll need to clarify the requirements fully with
> the manager first otherwise it's guesswork...
> Cheers,
> Paul Ibison
>

Sunday, March 11, 2012

DB Question

I took one online test on SQL Server Admin, Four qustions i was not sure
answer
can any provide me answer
1. If you want to be able access the customers table directly from a Web
browser,
what database name must you configure in with the IIS Virtual Directory
Management Tool?
2. While backing up a database to a tape drive, the tape runs out of
space. You
replace the tape. Referring to the scenario above, what is the
correct way
to complete the backup?
3. What is different between Cluster and non cluster.
4. When do you need to use the REPLACE switch while restoring databases?
Thanks
kalyanHi
Taking the questions out of context makes them even more vaguer than usual!!
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
>I took one online test on SQL Server Admin, Four qustions i was not sure
> answer
> can any provide me answer
> 1. If you want to be able access the customers table directly from a Web
> browser,
> what database name must you configure in with the IIS Virtual
> Directory
> Management Tool?
The database will be the database where the customers table is located. You
don't have to name your virtual directory with the same name as the database
and the IIS Virtual Directory Management Tool allows you to create that
mapping.
> 2. While backing up a database to a tape drive, the tape runs out of
> space. You
> replace the tape. Referring to the scenario above, what is the
> correct way
> to complete the backup?
You will be prompted for the contiuation tape which once loaded you should
acknowledged Label and keep the tapes and when restoring the database load
the last tape first.
> 3. What is different between Cluster and non cluster.
Clustered tables and indexed views keep their data rows in order based on
the clustered index key
> 4. When do you need to use the REPLACE switch while restoring databases?
>
REPLACE will overwrite a database/datafile with the same name if they
already exist and bypasses checks that are made if you don't specify it.
You may want to check out books online for more detailed explanations.
John
> Thanks
> kalyan
>
>|||John
here is details about those questions
1. If you want to be able access the customers table directly from a Web
browser,
what database name must you configure in with the IIS Virtual Directory
Management Tool?
Choice 1
Dbobject
Choice 2
Xpath
Choice 3
Schema
Choice 4
Direct
Choice 5
Template
2. While backing up a database to a tape drive, the tape runs out of space.
You
replace the tape. Referring to the scenario above, what is the correct
way to
complete thebackup?
Choice 1
Repeat the previous backup command, adding the BEGIN option.
Choice 2
Repeat the previous backup command, adding the INIT option.
Choice 3
Repeat the previous backup command, adding the NOINIT option.
Choice 4
Repeat the previous backup command, adding the RESTART option.
Choice 5
Repeat the previous backup command, adding the BACKUP option.
Following is general question of my own not from any test
What is different between Cluster and non cluster.
When do you need to use the REPLACE switch while restoring databases?
Thanks
Kalyan
"John Bell" wrote:
> Hi
> Taking the questions out of context makes them even more vaguer than usual!!
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
> >I took one online test on SQL Server Admin, Four qustions i was not sure
> > answer
> > can any provide me answer
> >
> > 1. If you want to be able access the customers table directly from a Web
> > browser,
> > what database name must you configure in with the IIS Virtual
> > Directory
> > Management Tool?
> The database will be the database where the customers table is located. You
> don't have to name your virtual directory with the same name as the database
> and the IIS Virtual Directory Management Tool allows you to create that
> mapping.
> >
> > 2. While backing up a database to a tape drive, the tape runs out of
> > space. You
> > replace the tape. Referring to the scenario above, what is the
> > correct way
> > to complete the backup?
> You will be prompted for the contiuation tape which once loaded you should
> acknowledged Label and keep the tapes and when restoring the database load
> the last tape first.
> >
> > 3. What is different between Cluster and non cluster.
> Clustered tables and indexed views keep their data rows in order based on
> the clustered index key
> >
> > 4. When do you need to use the REPLACE switch while restoring databases?
> >
> REPLACE will overwrite a database/datafile with the same name if they
> already exist and bypasses checks that are made if you don't specify it.
> You may want to check out books online for more detailed explanations.
> John
>
> > Thanks
> > kalyan
> >
> >
> >
>
>|||Hi
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:F88206C9-4021-48C7-82D2-35909D3B77DC@.microsoft.com...
> John
> here is details about those questions
> 1. If you want to be able access the customers table directly from a Web
> browser,
> what database name must you configure in with the IIS Virtual
> Directory
> Management Tool?
> Choice 1
> Dbobject
> Choice 2
> Xpath
> Choice 3
> Schema
> Choice 4
> Direct
> Choice 5
> Template
It is DBObject as described in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_8e7t.asp
> 2. While backing up a database to a tape drive, the tape runs out of
> space.
> You
> replace the tape. Referring to the scenario above, what is the
> correct
> way to
> complete thebackup?
> Choice 1
> Repeat the previous backup command, adding the BEGIN option.
> Choice 2
> Repeat the previous backup command, adding the INIT option.
> Choice 3
> Repeat the previous backup command, adding the NOINIT option.
> Choice 4
> Repeat the previous backup command, adding the RESTART option.
> Choice 5
> Repeat the previous backup command, adding the BACKUP option.
>
I would expect this to be RESTART.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_35ww.asp
>
> Following is general question of my own not from any test
> What is different between Cluster and non cluster.
Check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp
> When do you need to use the REPLACE switch while restoring databases?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp?frame=true
John
> Thanks
> Kalyan
> "John Bell" wrote:
>> Hi
>> Taking the questions out of context makes them even more vaguer than
>> usual!!
>> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
>> news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
>> >I took one online test on SQL Server Admin, Four qustions i was not
>> >sure
>> > answer
>> > can any provide me answer
>> >
>> > 1. If you want to be able access the customers table directly from a
>> > Web
>> > browser,
>> > what database name must you configure in with the IIS Virtual
>> > Directory
>> > Management Tool?
>> The database will be the database where the customers table is located.
>> You
>> don't have to name your virtual directory with the same name as the
>> database
>> and the IIS Virtual Directory Management Tool allows you to create that
>> mapping.
>> >
>> > 2. While backing up a database to a tape drive, the tape runs out of
>> > space. You
>> > replace the tape. Referring to the scenario above, what is the
>> > correct way
>> > to complete the backup?
>> You will be prompted for the contiuation tape which once loaded you
>> should
>> acknowledged Label and keep the tapes and when restoring the database
>> load
>> the last tape first.
>> >
>> > 3. What is different between Cluster and non cluster.
>> Clustered tables and indexed views keep their data rows in order based on
>> the clustered index key
>> >
>> > 4. When do you need to use the REPLACE switch while restoring
>> > databases?
>> >
>> REPLACE will overwrite a database/datafile with the same name if they
>> already exist and bypasses checks that are made if you don't specify it.
>> You may want to check out books online for more detailed explanations.
>> John
>>
>> > Thanks
>> > kalyan
>> >
>> >
>> >
>>

DB Question

I took one online test on SQL Server Admin, Four qustions i was not sure
answer
can any provide me answer
1. If you want to be able access the customers table directly from a Web
browser,
what database name must you configure in with the IIS Virtual Directory
Management Tool?
2. While backing up a database to a tape drive, the tape runs out of
space. You
replace the tape. Referring to the scenario above, what is the
correct way
to complete the backup?
3. What is different between Cluster and non cluster.
4. When do you need to use the REPLACE switch while restoring databases?
Thanks
kalyanHi
Taking the questions out of context makes them even more vaguer than usual!!
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
>I took one online test on SQL Server Admin, Four qustions i was not sure
> answer
> can any provide me answer
> 1. If you want to be able access the customers table directly from a Web
> browser,
> what database name must you configure in with the IIS Virtual
> Directory
> Management Tool?
The database will be the database where the customers table is located. You
don't have to name your virtual directory with the same name as the database
and the IIS Virtual Directory Management Tool allows you to create that
mapping.

> 2. While backing up a database to a tape drive, the tape runs out of
> space. You
> replace the tape. Referring to the scenario above, what is the
> correct way
> to complete the backup?
You will be prompted for the contiuation tape which once loaded you should
acknowledged Label and keep the tapes and when restoring the database load
the last tape first.

> 3. What is different between Cluster and non cluster.
Clustered tables and indexed views keep their data rows in order based on
the clustered index key

> 4. When do you need to use the REPLACE switch while restoring databases?
>
REPLACE will overwrite a database/datafile with the same name if they
already exist and bypasses checks that are made if you don't specify it.
You may want to check out books online for more detailed explanations.
John

> Thanks
> kalyan
>
>|||John
here is details about those questions
1. If you want to be able access the customers table directly from a Web
browser,
what database name must you configure in with the IIS Virtual Directory
Management Tool?
Choice 1
Dbobject
Choice 2
Xpath
Choice 3
Schema
Choice 4
Direct
Choice 5
Template
2. While backing up a database to a tape drive, the tape runs out of space.
You
replace the tape. Referring to the scenario above, what is the correct
way to
complete thebackup?
Choice 1
Repeat the previous backup command, adding the BEGIN option.
Choice 2
Repeat the previous backup command, adding the INIT option.
Choice 3
Repeat the previous backup command, adding the NOINIT option.
Choice 4
Repeat the previous backup command, adding the RESTART option.
Choice 5
Repeat the previous backup command, adding the BACKUP option.
Following is general question of my own not from any test
What is different between Cluster and non cluster.
When do you need to use the REPLACE switch while restoring databases?
Thanks
Kalyan
"John Bell" wrote:

> Hi
> Taking the questions out of context makes them even more vaguer than usual
!!
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
> The database will be the database where the customers table is located. Yo
u
> don't have to name your virtual directory with the same name as the databa
se
> and the IIS Virtual Directory Management Tool allows you to create that
> mapping.
>
> You will be prompted for the contiuation tape which once loaded you should
> acknowledged Label and keep the tapes and when restoring the database load
> the last tape first.
>
> Clustered tables and indexed views keep their data rows in order based on
> the clustered index key
>
> REPLACE will overwrite a database/datafile with the same name if they
> already exist and bypasses checks that are made if you don't specify it.
> You may want to check out books online for more detailed explanations.
> John
>
>
>
>|||Hi
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:F88206C9-4021-48C7-82D2-35909D3B77DC@.microsoft.com...
> John
> here is details about those questions
> 1. If you want to be able access the customers table directly from a Web
> browser,
> what database name must you configure in with the IIS Virtual
> Directory
> Management Tool?
> Choice 1
> Dbobject
> Choice 2
> Xpath
> Choice 3
> Schema
> Choice 4
> Direct
> Choice 5
> Template
It is DBObject as described in
7t.asp" target="_blank">http://msdn.microsoft.com/library/d...e
7t.asp

> 2. While backing up a database to a tape drive, the tape runs out of
> space.
> You
> replace the tape. Referring to the scenario above, what is the
> correct
> way to
> complete thebackup?
> Choice 1
> Repeat the previous backup command, adding the BEGIN option.
> Choice 2
> Repeat the previous backup command, adding the INIT option.
> Choice 3
> Repeat the previous backup command, adding the NOINIT option.
> Choice 4
> Repeat the previous backup command, adding the RESTART option.
> Choice 5
> Repeat the previous backup command, adding the BACKUP option.
>
I would expect this to be RESTART.
35ww.asp" target="_blank">http://msdn.microsoft.com/library/d...br />
35ww.asp

>
> Following is general question of my own not from any test
> What is different between Cluster and non cluster.
Check out
http://msdn.microsoft.com/library/d...ar_da2_8sit.asp[
vbcol=seagreen]
> When do you need to use the REPLACE switch while restoring databases?[/vbcol]
25rm.asp?frame=true" target="_blank">http://msdn.microsoft.com/library/d...asp?frame=true
John
[vbcol=seagreen]
> Thanks
> Kalyan
> "John Bell" wrote:
>

Wednesday, March 7, 2012

DB move from MySQL to MSSQL 2000

Hey everyone!
FYI - I am not a DB admin or a developer but I am responsible for this... Anyway, I have a 20MB SQL script from a MySQL server that contains all of the table structures and data from a DB. I need to somehow import this into a new SQL 2000 DB. I've al
ready modified the syntax of the script to fix what is obviously (to me at least) wrong - Comments from '#' to '--' things like that. When I put the .SQL file into Query Analyzer it spits up all over me complaining about auto_increment and also with TYP
E=MyISAM. I've realized that MySQL is very different from MSSQL in some ways but I'm not sure where to start. All I have (and will ever have) is the .SQL file from MySQL. I'm in a situation where I don't have access to a lot of outside help and I reall
y need to get this data into our MSSQL server. Here's a small chunk of the MySQL code that I need to import. If this can be made to work I can duplicate the changes to the rest of the script...
CREATE TABLE `SampleTable` (
`Field1` int(10) NOT NULL auto_increment,
`Field2` int(10) NOT NULL default '0',
`Field3` int(10) NOT NULL default '0',
`Field4` float(5,2) NOT NULL default '0.00',
PRIMARY KEY (`Field1`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
> CREATE TABLE `SampleTable` (
> `Field1` int(10) NOT NULL auto_increment,
> `Field2` int(10) NOT NULL default '0',
> `Field3` int(10) NOT NULL default '0',
> `Field4` float(5,2) NOT NULL default '0.00',
> PRIMARY KEY (`Field1`)
> ) TYPE=MyISAM AUTO_INCREMENT=11 ;
Here is your sample
CREATE TABLE SampleTable (
Field1 int NOT NULL identity(1,1),
Field2 int NOT NULL default 0,
Field3 int NOT NULL default 0,
Field4 numeric(5,2) NOT NULL default 0.00,
PRIMARY KEY (Field1)
)
GO
drop table SampleTable
GO
Bojidar Alexandrov

DB move from MySQL to MSSQL 2000

Hey everyone!
FYI - I am not a DB admin or a developer but I am responsible for this...
Anyway, I have a 20MB SQL script from a mysql server that contains all of t
he table structures and data from a DB. I need to somehow import this into
a new SQL 2000 DB. I've al
ready modified the syntax of the script to fix what is obviously (to me at l
east) wrong - Comments from '#' to '--' things like that. When I put the .
SQL file into Query Analyzer it spits up all over me complaining about auto_
increment and also with TYP
E=MyISAM. I've realized that mysql is very different from MSSQL in some way
s but I'm not sure where to start. All I have (and will ever have) is the .
SQL file from MySQL. I'm in a situation where I don't have access to a lot
of outside help and I reall
y need to get this data into our MSSQL server. Here's a small chunk of the
MySQL code that I need to import. If this can be made to work I can duplica
te the changes to the rest of the script...
CREATE TABLE `SampleTable` (
`Field1` int(10) NOT NULL auto_increment,
`Field2` int(10) NOT NULL default '0',
`Field3` int(10) NOT NULL default '0',
`Field4` float(5,2) NOT NULL default '0.00',
PRIMARY KEY (`Field1`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;> CREATE TABLE `SampleTable` (
> `Field1` int(10) NOT NULL auto_increment,
> `Field2` int(10) NOT NULL default '0',
> `Field3` int(10) NOT NULL default '0',
> `Field4` float(5,2) NOT NULL default '0.00',
> PRIMARY KEY (`Field1`)
> ) TYPE=MyISAM AUTO_INCREMENT=11 ;
Here is your sample
CREATE TABLE SampleTable (
Field1 int NOT NULL identity(1,1),
Field2 int NOT NULL default 0,
Field3 int NOT NULL default 0,
Field4 numeric(5,2) NOT NULL default 0.00,
PRIMARY KEY (Field1)
)
GO
drop table SampleTable
GO
Bojidar Alexandrov

Thursday, March 29, 2012

DBA Contract without Local Admin priveleges

DBA Administration db

DBA Administration db

DBA Admin

DBA Admin

DBA Admin

Wednesday, March 21, 2012

db seperation

db seperation

db seperation

Sunday, March 11, 2012

DB Question

DB Question

DB Question

Wednesday, March 7, 2012

DB move from MySQL to MSSQL 2000

DB move from MySQL to MSSQL 2000

DBCC CHECKDB

Blog Archive

About Me