Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different ways of moving data or databases
between servers and databases in SQL Server?
- 3 Answers
- 8366 Views
- I also Faced
- E-Mail Answers
Answer Posted / santo
export/import...attach/detach...DTS....backup/restore!
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how can you process messages in order asynchronously?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you find out if a table can be redefined?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what are the types of connection load-balancing?
What is a system database and what is a user database? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
what is the role of dip user in our database?
how can you initialize log miner?
what is ora 24313?what is the procedure to exclude that error?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
