Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raul11
Starting Member
48 Posts |
 Posted - 2011-08-31 : 08:58:51
|
| there is db test whose backup i want to use to restore to another db called test2. can this be done and what would be the syntaxThanx |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-31 : 09:01:38
|
| yep. this can be done. easiest way isto connect to your server using mangement studio. right expand server and choose databases right click and choose restore database and browse to your folder after selection from device option. then give it name as test2------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
raul11
Starting Member
48 Posts |
Posted - 2011-09-03 : 09:46:25
|
| how do i check if mirroring is in sync or not |
|
|
|
raul11
Starting Member
48 Posts |
Posted - 2011-09-07 : 06:17:16
|
| user db maintenance plan job failed. but there is no maintenance plan avaialble to check for failure..any suggestions how to check these |
|
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2011-09-07 : 15:31:14
|
| Can you clarify with any corresponding error messages? Is this job relating to the same db you restored from an existing db? Detail please :)?Steve |
|
|
|
|
|
|
query