how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.
Answer Posted / anwar hayat
Stop MS SQLServer Services and copy mdf ldf files in desire
location.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is coalesce in sql server?
We need to perform what steps in the following order to work with a cursor?
How many replicas are maintained for each SQL Azure database?
Write a code to select distinct records without using the DISTINCT keyword.
What is 3nf normalization?
Do you know what are the differences between lost updates and uncommitted dependencies?
In what sequence sql statement is processed?
What is triggers in ms sql server?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are alternate keys?
What are out-of-range errors with date and time literals?
What is an inner join?
How many clustered indexes there can be on table ?
What is a document index?