Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-09 : 02:13:30
|
| 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 clustering6. In 2000 we have DTs package.can we run the same DTS package in 2005. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 09:29:02
|
| 1)Check this out: http://deepakinsql.blogspot.com/2007/08/how-to-recover-from-suspect-database.html2)Check Moving system files in SQL server in BOL.3)You can move tables to different FG if the table has clustered index.4)I don't think so.5)Another i.p address (that will be virtual i.p)6)Yes. This have execute DTS Package task. But maynot work.You need to understand SQL server with BOL. |
 |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-04-09 : 12:46:10
|
| Thanks For the answers.Ok.Could you tell me a little more briefly abt ip address.So from where we can take the ip address to implement clustering. |
|
|
|
dcunningham
Starting Member
25 Posts |
Posted - 2008-04-09 : 14:16:29
|
| In setting up clustering, You'll have the following per NODE:1) An IP address for the server. This is the one issued by your DHCP or static2) An IP address that is classified as a virtual IP. This will be used by your application server to connect to the database.3) Optional: Heartbeat IP that will go betweeen the nodes of the servers.I hope this helps you.DaleDBA Intuit. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-09 : 23:11:36
|
| Need another virtual ip address for cluster name.Regarding move tables to other file group, right click on the table in ssms and choose design. Then change file group in properties, works even table doesn't have clustered index. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 23:44:28
|
| 'Then change file group in properties, works even table doesn't have clustered index.'Don't think so. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 23:10:29
|
| Did you ever try that? I did that many times by the way. |
|
|
|
|
|
|
int questions