sandhyarao49 (4/10/2008)
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.
These look like DBA interview questions.
If we told you, you would simply memorize, perhaps badly. You need to do all these things to understand them. Get yourself a copy of the Developer's Edition and start learning.
To be honest, if you haven't done the first 3 a dozen times each before you apply for a job in the world of SQL Server, you need to study a whole lot more before you consider applying for the job.
You should also learn how to use Google. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.