Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug in SQL Server 2005 RTM?
Message
 
 
To
07/01/2008 01:23:27
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01279775
Message ID:
01280178
Views:
20
>OK, the Restore didn't run correctly, even though the commands looked ok ... got a few errors, but I may have goofed something up. It's late.
>
>Time for me to quit geeking out and think about going upstairs and get to bed, but I'll check back with you in the morning to see if you've gotten any better results.
>
>~~Bonnie
>

Hi Bonnie,

I re-tried all steps at home and the STOPAT clause was not generated again.

Here are my steps, may be something is wrong:

After I created a database and a table, I click on Tasks, Backup. Select database, specify name of the backup and expiration (1).

Then repeat it for Log file.

Then do changes.

Backup log again.

Then select Restore database. Click on the button close to most recent backup and select some time about 2 minutes ago. Check data and first backup file. Then press Script button and there is no STOPAT option in the generated command. The Restore failed, though, saying I have to select STOPAT or NORECOVERY option. But I just did?

Anyway, it was a quick try, I may try it again.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform