Showing posts with label restore. Show all posts
Showing posts with label restore. Show all posts

Wednesday, March 21, 2012

Queries for Back up and restore the databases

Hi,
I would like to know what are the queries for back up and restore of
the DB in SQL Server.
Kindly help. Thanks in advance.
urs,
Sundar The Great!Good ol' Books Online says:
http://msdn.microsoft.com/library/d...br />
35ww.asp
http://msdn.microsoft.com/library/d...br />
25rm.asp
Only *you* know what you actually need. Unless you tell us.
ML
http://milambda.blogspot.com/

Friday, March 9, 2012

Q319697

SQL Enterprise Manager Restore to Point in Time Does Not
Stop at Requested Time
and the Database is Left in a Loading State 'Q319697'
Has anybody had problems similar to the one high-lighted
in Q319697.
Earlier this week I tried to Recover a database to a
specific point in time
but the restore went to the end of the file.
I have SP3 and MS03-031 hot fix installed both on my PC
and the server I was restoring to.
The Knowledge base article says that it is fixed in SP3,
has MS03-031 caused this?
After the initial panic I managed to restore the database
using SQL.
GaryI have the same problem that you describe even if I have SP3 installed.. Th
is is not related to MS03-031 hot fix because I don't have installed this on
e

Q319697

SQL Enterprise Manager Restore to Point in Time Does Not
Stop at Requested Time
and the Database is Left in a Loading State 'Q319697'
Has anybody had problems similar to the one high-lighted
in Q319697.
Earlier this week I tried to Recover a database to a
specific point in time
but the restore went to the end of the file.
I have SP3 and MS03-031 hot fix installed both on my PC
and the server I was restoring to.
The Knowledge base article says that it is fixed in SP3,
has MS03-031 caused this?
After the initial panic I managed to restore the database
using SQL.
GaryI have the same problem that you describe even if I have SP3 installed.. This is not related to MS03-031 hot fix because I don't have installed this one