June 20, 2009 at 9:16 am
1.SP1 version number like (2047)
2.How many type of mirroring
3.Difference between transaction replication and merge replication
4.If your database primary file size is 40 GB and log file size 60 GB . Then how much space you need to take backup or for restore that database
5.How you manage the memory of your database
6.Load balancing is supported by sql 2005 ?
7.Syntax for transaction log backup file
8.How you check the space use by log file
9.Difference between sql 2000 and sql 2005
10.Which command use to find the block process id activity
11. If replication is failed because of network issue . what configuration we need to configure to start the merge replication or log shipping to run automatically
12.If mirror database is full, how we can spring the file
13.If dbcc shrink does not shrink the log , how you trouble shoot this issue
June 20, 2009 at 9:59 am
Well that's lot many questions and each one of them require(perhaps) separate threads.
narinder (6/20/2009)
1.SP1 version number like (2047)
What is the question here?
2.How many type of mirroring[/quote] If you're running sql 2005 and higher, mirroring is supported. i guess mirroring in SP1 requires instance to be restarted using trace flag 1400. Pls cross check with BOL.
3.Difference between transaction replication and merge replication
http://msdn.microsoft.com/en-us/library/ms152531(SQL.90).aspx has links for each type of replication. You can compare that.
4.If your database primary file size is 40 GB and log file size 60 GB . Then how much space you need to take backup or for restore that database
That's unusual. you need to figure why the size of the log file is so huge? is some huge insert/update query running all the time? how often do you take log backups? do u put ur db recovery model in bulk insert mode if performing bulk inserts?
5.How you manage the memory of your database
SQL Server is capable of using consuming memory it requires which it requests from the underlying OS. You may want to configure min/max server memory depending on how much memory you have. also if ur server is 32 bit, you may want to enable PAE and AWE for using memory more than 4GB (if you have more than 4 gb of memory). Refer BOL for details.
6.Load balancing is supported by sql 2005 ?
I guess there are various methods, one of which i prefer is peer to peer replication
7.Syntax for transaction log backup file
complete syntax of backup is here. http://msdn.microsoft.com/en-us/library/ms186865(SQL.90).aspx"> http://msdn.microsoft.com/en-us/library/ms186865(SQL.90).aspx
8.How you check the space use by log file
sp_spaceused
9.Difference between sql 2000 and sql 2005
You might want to browse net for this and refer BOL.
10.Which command use to find the block process id activity
You can query sys.dm_os_waiting_tasks view.
11. If replication is failed because of network issue . what configuration we need to configure to start the merge replication or log shipping to run automatically
You need to figure out why it failed. And need to resume it.
12.If mirror database is full, how we can spring the file
Can u elaborate more.
13.If dbcc shrink does not shrink the log , how you trouble shoot this issue
You need to figure out what's preventing the log files to be shrink. Also shrinking a file is not a good option. Do you mean log truncation here?
June 20, 2009 at 10:23 am
narinder (6/20/2009)
1.SP1 version number like (2047)2.How many type of mirroring
3.Difference between transaction replication and merge replication
4.If your database primary file size is 40 GB and log file size 60 GB . Then how much space you need to take backup or for restore that database
5.How you manage the memory of your database
6.Load balancing is supported by sql 2005 ?
7.Syntax for transaction log backup file
8.How you check the space use by log file
9.Difference between sql 2000 and sql 2005
10.Which command use to find the block process id activity
11. If replication is failed because of network issue . what configuration we need to configure to start the merge replication or log shipping to run automatically
12.If mirror database is full, how we can spring the file
13.If dbcc shrink does not shrink the log , how you trouble shoot this issue
Okay, Pradeep Singh has already given you some very short answers. Now, your homework is to go out and find answers to your questions first and then come back and see if you are right.
If these questions are for school, it is important for you to figure out the answers, not have them handed to you. If these are interview questions, then it is even more important for you to figure out the answers yourself. We aren't here to help you get a job for which you aren't qualified.
June 20, 2009 at 10:50 am
I will second Lynn's answers. We are happy to help, but we are not here to do your job, or answer questions you haven't done any work on.
I'd prefer it if you show some effort before we answer the questions.
June 20, 2009 at 2:06 pm
Are these interview questions or homework questions. They sound like the former.
May I suggest that you start by reading through books online? You'll probably find quite a few of the answers in there. Many of the others you'll find with a good google search. If you don't understand the answers, we'll help you, but we're not going to answer a quiz-show type set of questions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply