Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
1 5166What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
2762Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
2 6917
How do you implement session management in SQL Server mode?
Tell me what is the stuff and how does it differ from the replace function?
What is awe?
How to create a store procedure with encryption?
What are functions in the sql server?
Explain activity monitors
How do you check sql server is up and running?
What is the default sql server instance name?
how to take backup bcp out for a column in table in sql server?
Can we insert data into view sql server?
What is microsoft sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Explain hostprotectionattribute in sql server 2005?
How to find index size for each index on table?
How to implement service broker?