Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Administration
»
interview questions
interview questions
Rate Topic
Display Mode
Topic Options
Author
Message
sandhyarao49
sandhyarao49
Posted Wednesday, April 09, 2008 11:04 AM
SSC Journeyman
Group: General Forum Members
Last Login: 2 days ago @ 8:57 PM
Points: 88,
Visits: 410
Hi Could any one tell me the answers for these questions.
1. how do we troubleshoot a datbase if it is in suspect mode.What is the reason for a database to be in suspect mode.
2. how can we move a file from C drive to D drive, so that the file location in C drive is completely moved .
3.In a particular primary file group there are many objects.
How can we move some of the objects from this primary file group in to another file group.
4. can we install a sql server on a remote server so that it will not ask any inputs like domain name, authentication modes. .
5.If we want to implement clustering , can we use the virtual ip address on clustering as the ip address of our system or we have to use another ip address for clustering
6. In 2000 we have DTs package.can we run the same DTS package in 2005.
Post #482499
GSquared
GSquared
Posted Wednesday, April 09, 2008 11:14 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:24 PM
Points: 8,665,
Visits: 4,943
If these are interview questions for you trying to get a job, I'd have to say the answer is, "I don't know, but I can look it up." If that's the honest answer, for you, then that's the answer to give.
(I have to admit, I don't understand question 4, and don't know the answer to 5, but the rest seem pretty basic. 5 I'd look up, 4 I'd have to ask for clarification.)
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #482501
GilaMonster
GilaMonster
Posted Wednesday, April 09, 2008 1:36 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 2:52 PM
Points: 17,103,
Visits: 12,204
Is this for a written interview test, or did someone ask you these?
If you're trying to memorise answers for an interview, don't. A good interviewer can see through that very quickly.
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
Post #482582
ashish.kuriyal
ashish.kuriyal
Posted Monday, February 08, 2010 2:32 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 9:39 PM
Points: 34,
Visits: 765
sorry for late, might be you already got the answer. I am just answering on my behalf and you can judge how correct I am :-
1. how do we troubleshoot a datbase if it is in suspect mode.What is the reason for a database to be in suspect mode :- Check the errorlog of sql. If 2005 then it will be good as you can filter based on database. Check data/log files are at its place. Worse scenario when power failure and transaction is corrupt which make this situation, start implementing disaster recovery.
2. how can we move a file from C drive to D drive, so that the file location in C drive is completely moved . :- take database offline/online. Use detach/attach. If the same configuration you want for all coming databse, make this setting in msdb.
3.In a particular primary file group there are many objects.
How can we move some of the objects from this primary file group in to another file group. :-
I think alter database can help. for perticular table, create index and mention the perticular filegroup.
4. can we install a sql server on a remote server so that it will not ask any inputs like domain name, authentication modes. .
even if you install on remote server, it will ask.
5.If we want to implement clustering , can we use the virtual ip address on clustering as the ip address of our system or we have to use another ip address for clustering
There are in total 5 ip used for cluster which are physical ip.
6. In 2000 we have DTs package.can we run the same DTS package in 2005.
yes, open the DTS using SSIS.
Regards
Ashish
(if drink and drive is prohibited, why pubs and bars have parking space??)
Post #861501
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use