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.
Showing posts with label restoration. Show all posts
Showing posts with label restoration. Show all posts
Friday, March 30, 2012
Partial Restoration
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.
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.
Partial Restoration
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.
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.
Subscribe to:
Posts (Atom)