What are the different ways of moving data or databases
between servers and databases in SQL Server?
Answer Posted / santo
export/import...attach/detach...DTS....backup/restore!
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is a user-defined lock?
how can a session indicate its interest in receiving alerts?
Query processing is slow(eg select query)how will u solve that
What is fill factor? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Explain materialized views and how they are used.
who owns the operating system files created by the utl_file package?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you connect from 10g user to 11g user??
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Why would you use sql agent? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Which autogrowth database setting is good? : sql server DBA
what is the role of dip user in our database?