Hello,
I am using SQL 2000 Server.
I've backedup one of my SQL server Database with the
password using sql statement like :
Backup database <databasename> to <devicename> with
password=''?'
But after a few months I forget the password what I have
given during backup. Now I could not restore the database
from the backup file.
1) How can I restore the Database from the backup file
without password or
2) How can I know what the password is given during backup
Thanks
Shafinur
MCP, MCSD, MCDBA
tiptopsr@.agni.comThis is a multi-part message in MIME format.
--=_NextPart_000_002E_01C3B1AC.31729530
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I'm afraid you're out of luck. Part of backing up with a password is
keeping the password in a secure place - like the company safe - or just
remembering well.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Shafinur" <tiptopsr@.agni.com> wrote in message
news:066701c3b1d3$cc53b6c0$a301280a@.phx.gbl...
Hello,
I am using SQL 2000 Server.
I've backedup one of my SQL server Database with the
password using sql statement like :
Backup database <databasename> to <devicename> with
password=''?'
But after a few months I forget the password what I have
given during backup. Now I could not restore the database
from the backup file.
1) How can I restore the Database from the backup file
without password or
2) How can I know what the password is given during backup
Thanks
Shafinur
MCP, MCSD, MCDBA
tiptopsr@.agni.com
--=_NextPart_000_002E_01C3B1AC.31729530
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=3D"text/html; =charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DTahoma size=3D2>I'm afraid you're out of luck. =Part of backing up with a password is keeping the password in a secure place - =like the company safe - or just remembering well.</FONT></DIV>
<DIV><BR>-- <BR> Tom</DIV>
<DIV> </DIV>
<DIV>----<BR>Thomas A. =Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL Server Professional<BR>Toronto, ON Canada<BR><A href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A><BR>.</DIV>
<DIV>"Shafinur" <<A =href=3D"mailto:tiptopsr@.agni.com">tiptopsr@.agni.com</A>> wrote in message <A href=3D"news:066701c3b1d3$cc53b6c0$a301280a@.phx.gbl">news:066701c3b1d3$cc=53b6c0$a301280a@.phx.gbl</A>...</DIV>Hello,<BR>I am using SQL 2000 Server.<BR>I've backedup one of my SQL server Database =with the <BR>password using sql statement like :<BR><BR>Backup database <databasename> to <devicename> with =<BR>password=3D''?'<BR><BR>But after a few months I forget the password what I have <BR>given during =backup. Now I could not restore the database <BR>from the backup file.<BR><BR>1) =How can I restore the Database from the backup file <BR>without password =or<BR>2) How can I know what the password is given during backup<BR><BR>Thanks<BR><BR>Shafinur<BR>MCP, MCSD, MCDBA<BR><A href=3D"mailto:tiptopsr@.agni.com">tiptopsr@.agni.com</A><BR><BR></BODY></H=TML>
--=_NextPart_000_002E_01C3B1AC.31729530--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment