point in time restore

hello everybody
i just tried to do the exercise of point in time restore with northwind
database.
First i took a complete database backup of northwind
then after 10 min i took a transaction log backup of northwind
now when i try to restore the northwind database
while restoring i get this erros as
"invalid value specified for stopat parameter, restore log is terminating
abnormally
also now my northwind database is showing as loading & nothing inside this
database is showing
can anyone please suggest where i'm wrong & what needs to be taken care
about while doing point in time restore.
Hi
Post the T-SQL code you used to do the restore.
Regards
Mike
"vishal" wrote:

> hello everybody
> i just tried to do the exercise of point in time restore with northwind
> database.
> First i took a complete database backup of northwind
> then after 10 min i took a transaction log backup of northwind
> now when i try to restore the northwind database
> while restoring i get this erros as
> "invalid value specified for stopat parameter, restore log is terminating
> abnormally
> also now my northwind database is showing as loading & nothing inside this
> database is showing
> can anyone please suggest where i'm wrong & what needs to be taken care
> about while doing point in time restore.
>
>

point in time restore

hello everybody
i just tried to do the exercise of point in time restore with northwind
database.
First i took a complete database backup of northwind
then after 10 min i took a transaction log backup of northwind
now when i try to restore the northwind database
while restoring i get this erros as
"invalid value specified for stopat parameter, restore log is terminating
abnormally
also now my northwind database is showing as loading & nothing inside this
database is showing
can anyone please suggest where i'm wrong & what needs to be taken care
about while doing point in time restore.
I'm guessing your format for specifying the stopat time was incorrect. Here
is a format that works:
STOPAT = 'Apr 15, 1998 12:00 AM'
What format did you use?
There reason your database is still loading is because your restore failed.
After you restored your full backup you probable specified norecovery, so
you could restore your transaction log. Then since your transaction log
failed SQL Server still thinks your transaction log backup needs to run
before anyone can get into the database. Hope this make sense.
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"vishal" <compaq@.smil.co.in> wrote in message
news:OCRoVCUpEHA.3464@.TK2MSFTNGP14.phx.gbl...
> hello everybody
> i just tried to do the exercise of point in time restore with northwind
> database.
> First i took a complete database backup of northwind
> then after 10 min i took a transaction log backup of northwind
> now when i try to restore the northwind database
> while restoring i get this erros as
> "invalid value specified for stopat parameter, restore log is terminating
> abnormally
> also now my northwind database is showing as loading & nothing inside this
> database is showing
> can anyone please suggest where i'm wrong & what needs to be taken care
> about while doing point in time restore.
>
>
|||Hi,
You are supposed to restore the backup in a new database, not with existing
database.
Steps to do the point in time restore :
1. Ensure that Northwind database is set to FULL Recovery model
2. Restore the FULL database backup with norecovery
3. Restore the transaction log backup one by one with NORECOVERY
4. Restore the last transaction log backup with RECOVERY and STOPAT option
See the below link
http://support.microsoft.com/?kbid=297468
Thanks
hari
MCDBA
"vishal" wrote:

> hello everybody
> i just tried to do the exercise of point in time restore with northwind
> database.
> First i took a complete database backup of northwind
> then after 10 min i took a transaction log backup of northwind
> now when i try to restore the northwind database
> while restoring i get this erros as
> "invalid value specified for stopat parameter, restore log is terminating
> abnormally
> also now my northwind database is showing as loading & nothing inside this
> database is showing
> can anyone please suggest where i'm wrong & what needs to be taken care
> about while doing point in time restore.
>
>

PLZZ HELP ! ERROR CONNECTING TO SQL SERVER

Hello everybody

i am getting problem in connecting my asp.net(c#) web application with Sql Server 2000 programatically on the page load of my web form

I wrote following code in the page load

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page
SqlConnection myConnection = new SqlConnection("server=(local);database=master;Integrated Security=SSPI");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from emp", myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds, "emp");

DataGrid1.DataSource=ds.Tables["emp"].DefaultView;
DataGrid1.DataBind();
}

Build OK but following exception occurred:

Server Error in '/datagridtest' Application.
------------------------

Login failed for user 'MATRIX\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'MATRIX\ASPNET'.

Source Error:

Line 27:
Line 28: DataSet ds = new DataSet();
Line 29: myCommand.Fill(ds, "emp"); //THIS APPEARS IN RED ON THE PAGE
Line 30:
Line 31: DataGrid1.DataSource=ds.Tables["emp"].DefaultView;

----------------------------
PLZ HELP ME, I THINK THE PROBLEM IS WITH CONNECTIONSTRING, I STUCK UP HERE FROM LAST 3 DAYS AND COULD NOT PROCEED WITH MY FURTHER STUDY AND PRACTICE

THANX IN ADVANCE

BSSGlad you got this worked out!view post 806235