We have taken a full database dump in sql server 2000.
Now we want to restore only the data file without restoring the log file .
will it be possible to do this.
Rajeev,
When you restore the database backup (we don't use the term 'dump' anymore)
SQL Server will automatically create a log file - every database must have
one.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Rajeev R" <Rajeev R@.discussions.microsoft.com> wrote in message
news:8535A309-7F5D-4D25-95DA-806CB3DFE323@.microsoft.com...
> We have taken a full database dump in sql server 2000.
> Now we want to restore only the data file without restoring the log file .
> will it be possible to do this.
No comments:
Post a Comment