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 4469What 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.
2344Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
2 5954
What is a schema in ms sql server 2005?
what do you understand by change data capture?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the data type of time?
What are various aggregate functions that are available?
How to write a query with a full outer join in ms sql server?
Which sql server table is used to hold the stored procedure script?
What is sql collation?
Do you know the isolation level that sql server support?
What happens if null values are involved in comparison operations?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is the difference between row_number and dense_rank?
Explain how does the report manager work in ssrs?
What is cdc in sql server?
What is the difference between Triggers and Stored Procedure?