|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0036_01C96B46.3098C1D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello people
I am trying to restore DB from a Live company (using SSMS, restore) to =
Test and following is the error message I get and can't do the restore.
System.data.sqlclient.sqlerror: exclusive access could not be obtained =
because the database is in use =20
Please help
------=_NextPart_000_0036_01C96B46.3098C1D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<META content=3D"MSHTML 6.00.6000.16788" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3DArial size=3D2>Hello people</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to restore DB from a Live =
company=20
(using SSMS, restore) to Test and following is the error message I get =
and can't=20
do the restore.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>System.data.sqlclient.sqlerror: =
exclusive access=20
could not be obtained because the database is in=20
use </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Please=20
help </FONT></DIV></BODY></HTML>
------=_NextPart_000_0036_01C96B46.3098C1D0--
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00E0_01C96B68.740D4F90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
You should ask this question to a newsgroup specifically dedicated to =
SQL-Server such as microsoft.public.sqlserver.server. This newsgroup is =
about problems using ADP against a SQL-Server and has nothing to do with =
problems exclusively related to SQL-Server.
Before reposting, you should also mention in your post if you are =
trying to restore the database over an existing database or to a new =
database or location. Adding other details might also help.
--=20
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Viol-8-R" <viol-8-r[ at ]hotmail.com> wrote in message =
news:CAE1B901-F554-438F-BBA5-7B48C67F37FA[ at ]microsoft.com...
Hello people
I am trying to restore DB from a Live company (using SSMS, restore) to =
Test and following is the error message I get and can't do the restore.
System.data.sqlclient.sqlerror: exclusive access could not be obtained =
because the database is in use =20
Please help
------=_NextPart_000_00E0_01C96B68.740D4F90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<META content=3D"MSHTML 6.00.6000.16788" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 name=3D"Compose message =
area"=20
CanvasTabStop=3D"true">
<DIV><FONT face=3DArial size=3D2>You should ask this question to a =
newsgroup=20
specifically dedicated to SQL-Server such as=20
microsoft.public.sqlserver.server. This newsgroup is about =
problems using=20
ADP against a SQL-Server and has nothing to do with problems=20
exclusively related to SQL-Server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Before reposting, you should also =
mention in=20
your post if you are trying to restore the database over an existing =
database or=20
to a new database or location. Adding other details might also=20
help.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><BR>-- <BR>Sylvain Lafontaine, =
ing.<BR>MVP -=20
Technologies Virtual-PC<BR>E-mail: sylvain aei ca (fill the blanks, no =
spam=20
please)</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Viol-8-R" <<A=20
href=3D"mailto:viol-8-r[ at ]hotmail.com">viol-8-r[ at ]hotmail.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:CAE1B901-F554-438F-BBA5-7B48C67F37FA[ at ]microsoft.com">news:CAE=
1B901-F554-438F-BBA5-7B48C67F37FA[ at ]microsoft.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hello people</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to restore DB from a Live =
company=20
(using SSMS, restore) to Test and following is the error message I get =
and=20
can't do the restore.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>System.data.sqlclient.sqlerror: =
exclusive access=20
could not be obtained because the database is in=20
use </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Please=20
help </FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_00E0_01C96B68.740D4F90--
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00C0_01C96B73.F9B109B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
No worries, I realized after I sent the message that I have touched the =
sensitive people
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam =
please)> wrote in message news:eWKUqJ5aJHA.4072[ at ]TK2MSFTNGP02.phx.gbl...
You should ask this question to a newsgroup specifically dedicated to =
SQL-Server such as microsoft.public.sqlserver.server. This newsgroup is =
about problems using ADP against a SQL-Server and has nothing to do with =
problems exclusively related to SQL-Server.
Before reposting, you should also mention in your post if you are =
trying to restore the database over an existing database or to a new =
database or location. Adding other details might also help.
--=20
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Viol-8-R" <viol-8-r[ at ]hotmail.com> wrote in message =
news:CAE1B901-F554-438F-BBA5-7B48C67F37FA[ at ]microsoft.com...
Hello people
I am trying to restore DB from a Live company (using SSMS, restore) =
to Test and following is the error message I get and can't do the =
restore.
System.data.sqlclient.sqlerror: exclusive access could not be =
obtained because the database is in use =20
Please help
------=_NextPart_000_00C0_01C96B73.F9B109B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<META content=3D"MSHTML 6.00.6000.16788" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3DArial size=3D2>No worries, I realized after I sent the =
message=20
that I have touched the sensitive people</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam =
please)> wrote in message <A=20
title=3D"news:eWKUqJ5aJHA.4072[ at ]TK2MSFTNGP02.phx.gbl
CTRL + Click =
to follow link"=20
=
href=3D"news:eWKUqJ5aJHA.4072[ at ]TK2MSFTNGP02.phx.gbl">news:eWKUqJ5aJHA.4072=
[ at ]TK2MSFTNGP02.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>You should ask this question to a =
newsgroup=20
specifically dedicated to SQL-Server such as=20
microsoft.public.sqlserver.server. This newsgroup is about =
problems=20
using ADP against a SQL-Server and has nothing to do with =
problems=20
exclusively related to SQL-Server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Before reposting, you should =
also mention=20
in your post if you are trying to restore the database over an =
existing=20
database or to a new database or location. Adding other details =
might=20
also help.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><BR>-- <BR>Sylvain Lafontaine, =
ing.<BR>MVP=20
- Technologies Virtual-PC<BR>E-mail: sylvain aei ca (fill the blanks, =
no spam=20
please)</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Viol-8-R" <<A=20
href=3D"mailto:viol-8-r[ at ]hotmail.com">viol-8-r[ at ]hotmail.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:CAE1B901-F554-438F-BBA5-7B48C67F37FA[ at ]microsoft.com">news:CAE=
1B901-F554-438F-BBA5-7B48C67F37FA[ at ]microsoft.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hello people</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to restore DB from a =
Live company=20
(using SSMS, restore) to Test and following is the error message I =
get and=20
can't do the restore.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>System.data.sqlclient.sqlerror: =
exclusive=20
access could not be obtained because the database is in=20
use </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Please=20
=
help </FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=
L>
------=_NextPart_000_00C0_01C96B73.F9B109B0--
|
|
|