How are SQL Server databases physically stored under
Windows 2000?

Answer Posted / laxman

stored as mdf & ldf files

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different backups available in sql server?

758


Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

737


What is lookup override?

770


How do I make a resultset scrollable?

716


How to create prepared statements using odbc_prepare()?

782






How do I know if localdb is running?

697


Explain the different types of joins?

745


Is foreign key unique?

750


What is the difference between DATETIME2 and DATETIME?

804


What are secondary xml indexes?

790


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

913


How can I know what locks are running on which resource?

708


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

765


How to list all objects in a given schema?

741


What stored by the tempdb ? : sql server database administration

763