What is the command to change the recovery model?
No Answer is Posted For this Question
Be the First to Post Answer
What is it unwise to create wide clustered index keys?
How does normalization work?
What is difference between inner join and join?
Why we use functions in sql server?
Do you know what is openxml in sql server?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How to Check if table exists in sql server?
Can two different columns be merged into single column? Show practically?
What is 1nf normalization form?
How to Install SQL SERVER 2005 remotely?
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
What 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.