By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,230 Members | 2,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,230 IT Pros & Developers. It's quick & easy.

How to restore backup from diff server to new server

harshadd
100+
P: 176



Pls see the above error
I am trying to restore backup taken on my clients server on my development server.
It gives me access denied error.
sa user is configured for mixed mode authentication.
pls see the attcment for error mesage.

rgds HND
Oct 13 '10 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
How are you restoring the backup? I'm not sure if you can restore an enterprise backed up database to a sql express.

~~ CK
Oct 13 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.