A coworker is repeatedly experiencing problems restoring database backups on
a new sql virtual server (clustered). He has restored a database backup
using enterprise manager. Enterprise manager told him that the restore has
completed without giving any errors. We can not access the database and
enterprise manager shows the status of the database as "Loading". I ran the
command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
basically saying that the database was not completely loaded or the restore
did not complete. Can anyone tell me what the problem is or tell me how to
avoid this scenario?
-SJHi
Have you checked the SQL Server log and the System Event log to see if there
is any additional information in them?
It is usually a good idea to post the exact error numbers and messages.
John
"SJ" wrote:
> A coworker is repeatedly experiencing problems restoring database backups
on
> a new sql virtual server (clustered). He has restored a database backup
> using enterprise manager. Enterprise manager told him that the restore ha
s
> completed without giving any errors. We can not access the database and
> enterprise manager shows the status of the database as "Loading". I ran t
he
> command RESTORE DATABASE <databasename> WITH RECOVERY and received an erro
r
> basically saying that the database was not completely loaded or the restor
e
> did not complete. Can anyone tell me what the problem is or tell me how t
o
> avoid this scenario?
> --
> -SJ|||Here is the error:
File '<logical file name>' was only partially restored by a database or file
restore. The entire file must be successfully restored before applying the
log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Enterprise manager told me "Restore of database '<databasename>' completed
successfully."
-SJ
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked the SQL Server log and the System Event log to see if the
re
> is any additional information in them?
> It is usually a good idea to post the exact error numbers and messages.
> John
> "SJ" wrote:
>|||Hi SJ
Check out:
http://groups.google.com/group/micr...27357de5278e8bd
John
"SJ" wrote:
[vbcol=seagreen]
> Here is the error:
> File '<logical file name>' was only partially restored by a database or fi
le
> restore. The entire file must be successfully restored before applying the
> log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Enterprise manager told me "Restore of database '<databasename>' completed
> successfully."
> -SJ
> "John Bell" wrote:
>
Showing posts with label backups. Show all posts
Showing posts with label backups. Show all posts
Thursday, March 29, 2012
Database Status = Loading
A coworker is repeatedly experiencing problems restoring database backups on
a new sql virtual server (clustered). He has restored a database backup
using enterprise manager. Enterprise manager told him that the restore has
completed without giving any errors. We can not access the database and
enterprise manager shows the status of the database as "Loading". I ran the
command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
basically saying that the database was not completely loaded or the restore
did not complete. Can anyone tell me what the problem is or tell me how to
avoid this scenario?
-SJ
Hi
Have you checked the SQL Server log and the System Event log to see if there
is any additional information in them?
It is usually a good idea to post the exact error numbers and messages.
John
"SJ" wrote:
> A coworker is repeatedly experiencing problems restoring database backups on
> a new sql virtual server (clustered). He has restored a database backup
> using enterprise manager. Enterprise manager told him that the restore has
> completed without giving any errors. We can not access the database and
> enterprise manager shows the status of the database as "Loading". I ran the
> command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> basically saying that the database was not completely loaded or the restore
> did not complete. Can anyone tell me what the problem is or tell me how to
> avoid this scenario?
> --
> -SJ
|||Here is the error:
File '<logical file name>' was only partially restored by a database or file
restore. The entire file must be successfully restored before applying the
log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Enterprise manager told me "Restore of database '<databasename>' completed
successfully."
-SJ
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked the SQL Server log and the System Event log to see if there
> is any additional information in them?
> It is usually a good idea to post the exact error numbers and messages.
> John
> "SJ" wrote:
|||Hi SJ
Check out:
http://groups.google.com/group/micro...7357de5278e8bd
John
"SJ" wrote:
[vbcol=seagreen]
> Here is the error:
> File '<logical file name>' was only partially restored by a database or file
> restore. The entire file must be successfully restored before applying the
> log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Enterprise manager told me "Restore of database '<databasename>' completed
> successfully."
> -SJ
> "John Bell" wrote:
a new sql virtual server (clustered). He has restored a database backup
using enterprise manager. Enterprise manager told him that the restore has
completed without giving any errors. We can not access the database and
enterprise manager shows the status of the database as "Loading". I ran the
command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
basically saying that the database was not completely loaded or the restore
did not complete. Can anyone tell me what the problem is or tell me how to
avoid this scenario?
-SJ
Hi
Have you checked the SQL Server log and the System Event log to see if there
is any additional information in them?
It is usually a good idea to post the exact error numbers and messages.
John
"SJ" wrote:
> A coworker is repeatedly experiencing problems restoring database backups on
> a new sql virtual server (clustered). He has restored a database backup
> using enterprise manager. Enterprise manager told him that the restore has
> completed without giving any errors. We can not access the database and
> enterprise manager shows the status of the database as "Loading". I ran the
> command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> basically saying that the database was not completely loaded or the restore
> did not complete. Can anyone tell me what the problem is or tell me how to
> avoid this scenario?
> --
> -SJ
|||Here is the error:
File '<logical file name>' was only partially restored by a database or file
restore. The entire file must be successfully restored before applying the
log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Enterprise manager told me "Restore of database '<databasename>' completed
successfully."
-SJ
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked the SQL Server log and the System Event log to see if there
> is any additional information in them?
> It is usually a good idea to post the exact error numbers and messages.
> John
> "SJ" wrote:
|||Hi SJ
Check out:
http://groups.google.com/group/micro...7357de5278e8bd
John
"SJ" wrote:
[vbcol=seagreen]
> Here is the error:
> File '<logical file name>' was only partially restored by a database or file
> restore. The entire file must be successfully restored before applying the
> log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Enterprise manager told me "Restore of database '<databasename>' completed
> successfully."
> -SJ
> "John Bell" wrote:
Database Status = Loading
A coworker is repeatedly experiencing problems restoring database backups on
a new sql virtual server (clustered). He has restored a database backup
using enterprise manager. Enterprise manager told him that the restore has
completed without giving any errors. We can not access the database and
enterprise manager shows the status of the database as "Loading". I ran the
command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
basically saying that the database was not completely loaded or the restore
did not complete. Can anyone tell me what the problem is or tell me how to
avoid this scenario?
--
-SJHi
Have you checked the SQL Server log and the System Event log to see if there
is any additional information in them?
It is usually a good idea to post the exact error numbers and messages.
John
"SJ" wrote:
> A coworker is repeatedly experiencing problems restoring database backups on
> a new sql virtual server (clustered). He has restored a database backup
> using enterprise manager. Enterprise manager told him that the restore has
> completed without giving any errors. We can not access the database and
> enterprise manager shows the status of the database as "Loading". I ran the
> command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> basically saying that the database was not completely loaded or the restore
> did not complete. Can anyone tell me what the problem is or tell me how to
> avoid this scenario?
> --
> -SJ|||Here is the error:
File '<logical file name>' was only partially restored by a database or file
restore. The entire file must be successfully restored before applying the
log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Enterprise manager told me "Restore of database '<databasename>' completed
successfully."
-SJ
"John Bell" wrote:
> Hi
> Have you checked the SQL Server log and the System Event log to see if there
> is any additional information in them?
> It is usually a good idea to post the exact error numbers and messages.
> John
> "SJ" wrote:
> > A coworker is repeatedly experiencing problems restoring database backups on
> > a new sql virtual server (clustered). He has restored a database backup
> > using enterprise manager. Enterprise manager told him that the restore has
> > completed without giving any errors. We can not access the database and
> > enterprise manager shows the status of the database as "Loading". I ran the
> > command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> > basically saying that the database was not completely loaded or the restore
> > did not complete. Can anyone tell me what the problem is or tell me how to
> > avoid this scenario?
> >
> > --
> > -SJ|||Hi SJ
Check out:
http://groups.google.com/group/microsoft.public.sqlserver.clients/browse_frm/thread/b5447588fe32acf0/527357de5278e8bd#527357de5278e8bd
John
"SJ" wrote:
> Here is the error:
> File '<logical file name>' was only partially restored by a database or file
> restore. The entire file must be successfully restored before applying the
> log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Enterprise manager told me "Restore of database '<databasename>' completed
> successfully."
> -SJ
> "John Bell" wrote:
> > Hi
> >
> > Have you checked the SQL Server log and the System Event log to see if there
> > is any additional information in them?
> >
> > It is usually a good idea to post the exact error numbers and messages.
> >
> > John
> >
> > "SJ" wrote:
> >
> > > A coworker is repeatedly experiencing problems restoring database backups on
> > > a new sql virtual server (clustered). He has restored a database backup
> > > using enterprise manager. Enterprise manager told him that the restore has
> > > completed without giving any errors. We can not access the database and
> > > enterprise manager shows the status of the database as "Loading". I ran the
> > > command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> > > basically saying that the database was not completely loaded or the restore
> > > did not complete. Can anyone tell me what the problem is or tell me how to
> > > avoid this scenario?
> > >
> > > --
> > > -SJ
a new sql virtual server (clustered). He has restored a database backup
using enterprise manager. Enterprise manager told him that the restore has
completed without giving any errors. We can not access the database and
enterprise manager shows the status of the database as "Loading". I ran the
command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
basically saying that the database was not completely loaded or the restore
did not complete. Can anyone tell me what the problem is or tell me how to
avoid this scenario?
--
-SJHi
Have you checked the SQL Server log and the System Event log to see if there
is any additional information in them?
It is usually a good idea to post the exact error numbers and messages.
John
"SJ" wrote:
> A coworker is repeatedly experiencing problems restoring database backups on
> a new sql virtual server (clustered). He has restored a database backup
> using enterprise manager. Enterprise manager told him that the restore has
> completed without giving any errors. We can not access the database and
> enterprise manager shows the status of the database as "Loading". I ran the
> command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> basically saying that the database was not completely loaded or the restore
> did not complete. Can anyone tell me what the problem is or tell me how to
> avoid this scenario?
> --
> -SJ|||Here is the error:
File '<logical file name>' was only partially restored by a database or file
restore. The entire file must be successfully restored before applying the
log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Enterprise manager told me "Restore of database '<databasename>' completed
successfully."
-SJ
"John Bell" wrote:
> Hi
> Have you checked the SQL Server log and the System Event log to see if there
> is any additional information in them?
> It is usually a good idea to post the exact error numbers and messages.
> John
> "SJ" wrote:
> > A coworker is repeatedly experiencing problems restoring database backups on
> > a new sql virtual server (clustered). He has restored a database backup
> > using enterprise manager. Enterprise manager told him that the restore has
> > completed without giving any errors. We can not access the database and
> > enterprise manager shows the status of the database as "Loading". I ran the
> > command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> > basically saying that the database was not completely loaded or the restore
> > did not complete. Can anyone tell me what the problem is or tell me how to
> > avoid this scenario?
> >
> > --
> > -SJ|||Hi SJ
Check out:
http://groups.google.com/group/microsoft.public.sqlserver.clients/browse_frm/thread/b5447588fe32acf0/527357de5278e8bd#527357de5278e8bd
John
"SJ" wrote:
> Here is the error:
> File '<logical file name>' was only partially restored by a database or file
> restore. The entire file must be successfully restored before applying the
> log.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Enterprise manager told me "Restore of database '<databasename>' completed
> successfully."
> -SJ
> "John Bell" wrote:
> > Hi
> >
> > Have you checked the SQL Server log and the System Event log to see if there
> > is any additional information in them?
> >
> > It is usually a good idea to post the exact error numbers and messages.
> >
> > John
> >
> > "SJ" wrote:
> >
> > > A coworker is repeatedly experiencing problems restoring database backups on
> > > a new sql virtual server (clustered). He has restored a database backup
> > > using enterprise manager. Enterprise manager told him that the restore has
> > > completed without giving any errors. We can not access the database and
> > > enterprise manager shows the status of the database as "Loading". I ran the
> > > command RESTORE DATABASE <databasename> WITH RECOVERY and received an error
> > > basically saying that the database was not completely loaded or the restore
> > > did not complete. Can anyone tell me what the problem is or tell me how to
> > > avoid this scenario?
> > >
> > > --
> > > -SJ
Sunday, March 11, 2012
Database Restores
I took some database backups from a client site to do some development.
There were 20G, 16G and 200MB
i ran it through EM but waited for like 20 minutes for the 20G and 16G but nothing happen. Went to Profiler -- there was no activity log for backup/restore events.
went to QA and tried to restore the backup -- with the stats option but still nothing happenned. The 200MB restore worked though. i have restored a databases over 20G but haven't really encountered this problem. Can anyone assist me ? or have come across this problem ?I have to bring 2 or 3 client databases in house a week. Our largest client db is only about 70 gb but here is my restore template. Never fails.
--STEP 1. Create the Database
CREATE DATABASE MyDatabase
--STEP 2. Get the physical file names
sp_helpdb MyDatabase
--STEP 3. Get the logical file names
RESTORE FILELISTONLY
FROM DISK = 'X:\MyBackup.BAK'
--STEP.4 RUN THE RECOVERY
ALTER DATABASE MyDatabase SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE MyDatabase
FROM DISK = 'X:\MyBackup.BAK'
WITH REPLACE,RECOVERY,STATS=10,
MOVE 'Logical_Data' TO 'D:\physical.mdf' ,
MOVE 'Logical_Log' TO 'E:\physiical.LDF'
GO
ALTER DATABASE MyDatabase SET MULTI_USER
GO
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
GO
USE MyDatabase
GO
DBCC SHRINKFILE(Logical_Log,1)
GO
USE MASTER
GO
ALTER DATABASE MyDatabase SET RECOVERY SIMPLE|||That's the sort of thing you should post for reference on sqlkit, Thrasy.|||I know. I am getting some stuff together. Sample code... I have an article started. I will probably start posting this weekend. I am looking forward to some biting criticism. Why don't you post your CSVtoINT thing and don't you have a first name \ last name from one field thing too. I just have a full version release coming plus customer projects by the end of the month and I am woefully behind.|||I have noticed a remarkable delay from issuing the restore command to the first status tick being reported. Esecially on large databases. It could be that SQL Server is verifying the backup before beginning the restore, but that would be a question for Microsoft.
There were 20G, 16G and 200MB
i ran it through EM but waited for like 20 minutes for the 20G and 16G but nothing happen. Went to Profiler -- there was no activity log for backup/restore events.
went to QA and tried to restore the backup -- with the stats option but still nothing happenned. The 200MB restore worked though. i have restored a databases over 20G but haven't really encountered this problem. Can anyone assist me ? or have come across this problem ?I have to bring 2 or 3 client databases in house a week. Our largest client db is only about 70 gb but here is my restore template. Never fails.
--STEP 1. Create the Database
CREATE DATABASE MyDatabase
--STEP 2. Get the physical file names
sp_helpdb MyDatabase
--STEP 3. Get the logical file names
RESTORE FILELISTONLY
FROM DISK = 'X:\MyBackup.BAK'
--STEP.4 RUN THE RECOVERY
ALTER DATABASE MyDatabase SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE MyDatabase
FROM DISK = 'X:\MyBackup.BAK'
WITH REPLACE,RECOVERY,STATS=10,
MOVE 'Logical_Data' TO 'D:\physical.mdf' ,
MOVE 'Logical_Log' TO 'E:\physiical.LDF'
GO
ALTER DATABASE MyDatabase SET MULTI_USER
GO
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
GO
USE MyDatabase
GO
DBCC SHRINKFILE(Logical_Log,1)
GO
USE MASTER
GO
ALTER DATABASE MyDatabase SET RECOVERY SIMPLE|||That's the sort of thing you should post for reference on sqlkit, Thrasy.|||I know. I am getting some stuff together. Sample code... I have an article started. I will probably start posting this weekend. I am looking forward to some biting criticism. Why don't you post your CSVtoINT thing and don't you have a first name \ last name from one field thing too. I just have a full version release coming plus customer projects by the end of the month and I am woefully behind.|||I have noticed a remarkable delay from issuing the restore command to the first status tick being reported. Esecially on large databases. It could be that SQL Server is verifying the backup before beginning the restore, but that would be a question for Microsoft.
Wednesday, March 7, 2012
Database Restore Error
Hi,
We use Veritas NetBackup to do backups and restore of SQL Server 2000
databases. Recently, I had to restore a backup of a database to another
server for getting some deleted records from the backup. For this I created a
new database on the other server with the same name and started a restore
with MOVE option from Veritas NetBackup. Even though it was a newly created
database on which the restore was being applied, Veritas NetBackup gave an
error message that:
DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
not be obtained because the database is in use.>
DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
is terminating abnormally.>
What could be the reason that Veritas NetBackup wasn't able to get an
exclusive access on a newly created database?
Thanks in advance.You don't need to create a database before restoring a backup. Chances are
you were still connected to that DB while attempting the restore.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
Hi,
We use Veritas NetBackup to do backups and restore of SQL Server 2000
databases. Recently, I had to restore a backup of a database to another
server for getting some deleted records from the backup. For this I created
a
new database on the other server with the same name and started a restore
with MOVE option from Veritas NetBackup. Even though it was a newly created
database on which the restore was being applied, Veritas NetBackup gave an
error message that:
DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
not be obtained because the database is in use.>
DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
is terminating abnormally.>
What could be the reason that Veritas NetBackup wasn't able to get an
exclusive access on a newly created database?
Thanks in advance.|||How do I do a restore of a database to another server if I do not create a
database first?
"Tom Moreau" wrote:
> You don't need to create a database before restoring a backup. Chances are
> you were still connected to that DB while attempting the restore.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> Hi,
> We use Veritas NetBackup to do backups and restore of SQL Server 2000
> databases. Recently, I had to restore a backup of a database to another
> server for getting some deleted records from the backup. For this I created
> a
> new database on the other server with the same name and started a restore
> with MOVE option from Veritas NetBackup. Even though it was a newly created
> database on which the restore was being applied, Veritas NetBackup gave an
> error message that:
> DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
> Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
> not be obtained because the database is in use.>
> DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
> is terminating abnormally.>
> What could be the reason that Veritas NetBackup wasn't able to get an
> exclusive access on a newly created database?
> Thanks in advance.
>|||Simply restore the database. NetBackup *shouldn't* need to have one already
there, though I haven't used the product myself.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
How do I do a restore of a database to another server if I do not create a
database first?
"Tom Moreau" wrote:
> You don't need to create a database before restoring a backup. Chances
> are
> you were still connected to that DB while attempting the restore.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> Hi,
> We use Veritas NetBackup to do backups and restore of SQL Server 2000
> databases. Recently, I had to restore a backup of a database to another
> server for getting some deleted records from the backup. For this I
> created
> a
> new database on the other server with the same name and started a restore
> with MOVE option from Veritas NetBackup. Even though it was a newly
> created
> database on which the restore was being applied, Veritas NetBackup gave an
> error message that:
> DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
> Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> could
> not be obtained because the database is in use.>
> DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> DATABASE
> is terminating abnormally.>
> What could be the reason that Veritas NetBackup wasn't able to get an
> exclusive access on a newly created database?
> Thanks in advance.
>|||Hi,
In the netbackup script you can mention the database name this script is
used to restore database.
Regards,
Amol Lembhe
"Tom Moreau" wrote:
> Simply restore the database. NetBackup *shouldn't* need to have one already
> there, though I haven't used the product myself.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
> How do I do a restore of a database to another server if I do not create a
> database first?
> "Tom Moreau" wrote:
> > You don't need to create a database before restoring a backup. Chances
> > are
> > you were still connected to that DB while attempting the restore.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> > Hi,
> >
> > We use Veritas NetBackup to do backups and restore of SQL Server 2000
> > databases. Recently, I had to restore a backup of a database to another
> > server for getting some deleted records from the backup. For this I
> > created
> > a
> > new database on the other server with the same name and started a restore
> > with MOVE option from Veritas NetBackup. Even though it was a newly
> > created
> > database on which the restore was being applied, Veritas NetBackup gave an
> > error message that:
> >
> > DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
> > Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> > could
> > not be obtained because the database is in use.>
> >
> > DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> > DATABASE
> > is terminating abnormally.>
> >
> > What could be the reason that Veritas NetBackup wasn't able to get an
> > exclusive access on a newly created database?
> >
> > Thanks in advance.
> >
> >
>|||So, does NetBackup require the existence of the DB before restoring it?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Amol Lembhe" <amolrl@.gmail.com> wrote in message
news:7E73614E-803D-46C0-8714-38A24F048A2C@.microsoft.com...
Hi,
In the netbackup script you can mention the database name this script is
used to restore database.
Regards,
Amol Lembhe
"Tom Moreau" wrote:
> Simply restore the database. NetBackup *shouldn't* need to have one
> already
> there, though I haven't used the product myself.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
> How do I do a restore of a database to another server if I do not create a
> database first?
> "Tom Moreau" wrote:
> > You don't need to create a database before restoring a backup. Chances
> > are
> > you were still connected to that DB while attempting the restore.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> > Hi,
> >
> > We use Veritas NetBackup to do backups and restore of SQL Server 2000
> > databases. Recently, I had to restore a backup of a database to another
> > server for getting some deleted records from the backup. For this I
> > created
> > a
> > new database on the other server with the same name and started a
> > restore
> > with MOVE option from Veritas NetBackup. Even though it was a newly
> > created
> > database on which the restore was being applied, Veritas NetBackup gave
> > an
> > error message that:
> >
> > DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>,
> > Message
> > Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> > could
> > not be obtained because the database is in use.>
> >
> > DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> > DATABASE
> > is terminating abnormally.>
> >
> > What could be the reason that Veritas NetBackup wasn't able to get an
> > exclusive access on a newly created database?
> >
> > Thanks in advance.
> >
> >
>|||No, netbackup does not require DB to be present before restoration.
Regards,
Amol Lembhe
"Tom Moreau" wrote:
> So, does NetBackup require the existence of the DB before restoring it?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Amol Lembhe" <amolrl@.gmail.com> wrote in message
> news:7E73614E-803D-46C0-8714-38A24F048A2C@.microsoft.com...
> Hi,
> In the netbackup script you can mention the database name this script is
> used to restore database.
> Regards,
> Amol Lembhe
>
> "Tom Moreau" wrote:
> > Simply restore the database. NetBackup *shouldn't* need to have one
> > already
> > there, though I haven't used the product myself.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
> > How do I do a restore of a database to another server if I do not create a
> > database first?
> >
> > "Tom Moreau" wrote:
> >
> > > You don't need to create a database before restoring a backup. Chances
> > > are
> > > you were still connected to that DB while attempting the restore.
> > >
> > > --
> > > Tom
> > >
> > > ----
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > > news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> > > Hi,
> > >
> > > We use Veritas NetBackup to do backups and restore of SQL Server 2000
> > > databases. Recently, I had to restore a backup of a database to another
> > > server for getting some deleted records from the backup. For this I
> > > created
> > > a
> > > new database on the other server with the same name and started a
> > > restore
> > > with MOVE option from Veritas NetBackup. Even though it was a newly
> > > created
> > > database on which the restore was being applied, Veritas NetBackup gave
> > > an
> > > error message that:
> > >
> > > DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>,
> > > Message
> > > Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> > > could
> > > not be obtained because the database is in use.>
> > >
> > > DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> > > DATABASE
> > > is terminating abnormally.>
> > >
> > > What could be the reason that Veritas NetBackup wasn't able to get an
> > > exclusive access on a newly created database?
> > >
> > > Thanks in advance.
> > >
> > >
> >
> >
>
We use Veritas NetBackup to do backups and restore of SQL Server 2000
databases. Recently, I had to restore a backup of a database to another
server for getting some deleted records from the backup. For this I created a
new database on the other server with the same name and started a restore
with MOVE option from Veritas NetBackup. Even though it was a newly created
database on which the restore was being applied, Veritas NetBackup gave an
error message that:
DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
not be obtained because the database is in use.>
DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
is terminating abnormally.>
What could be the reason that Veritas NetBackup wasn't able to get an
exclusive access on a newly created database?
Thanks in advance.You don't need to create a database before restoring a backup. Chances are
you were still connected to that DB while attempting the restore.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
Hi,
We use Veritas NetBackup to do backups and restore of SQL Server 2000
databases. Recently, I had to restore a backup of a database to another
server for getting some deleted records from the backup. For this I created
a
new database on the other server with the same name and started a restore
with MOVE option from Veritas NetBackup. Even though it was a newly created
database on which the restore was being applied, Veritas NetBackup gave an
error message that:
DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
not be obtained because the database is in use.>
DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
is terminating abnormally.>
What could be the reason that Veritas NetBackup wasn't able to get an
exclusive access on a newly created database?
Thanks in advance.|||How do I do a restore of a database to another server if I do not create a
database first?
"Tom Moreau" wrote:
> You don't need to create a database before restoring a backup. Chances are
> you were still connected to that DB while attempting the restore.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> Hi,
> We use Veritas NetBackup to do backups and restore of SQL Server 2000
> databases. Recently, I had to restore a backup of a database to another
> server for getting some deleted records from the backup. For this I created
> a
> new database on the other server with the same name and started a restore
> with MOVE option from Veritas NetBackup. Even though it was a newly created
> database on which the restore was being applied, Veritas NetBackup gave an
> error message that:
> DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
> Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could
> not be obtained because the database is in use.>
> DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
> is terminating abnormally.>
> What could be the reason that Veritas NetBackup wasn't able to get an
> exclusive access on a newly created database?
> Thanks in advance.
>|||Simply restore the database. NetBackup *shouldn't* need to have one already
there, though I haven't used the product myself.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
How do I do a restore of a database to another server if I do not create a
database first?
"Tom Moreau" wrote:
> You don't need to create a database before restoring a backup. Chances
> are
> you were still connected to that DB while attempting the restore.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> Hi,
> We use Veritas NetBackup to do backups and restore of SQL Server 2000
> databases. Recently, I had to restore a backup of a database to another
> server for getting some deleted records from the backup. For this I
> created
> a
> new database on the other server with the same name and started a restore
> with MOVE option from Veritas NetBackup. Even though it was a newly
> created
> database on which the restore was being applied, Veritas NetBackup gave an
> error message that:
> DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
> Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> could
> not be obtained because the database is in use.>
> DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> DATABASE
> is terminating abnormally.>
> What could be the reason that Veritas NetBackup wasn't able to get an
> exclusive access on a newly created database?
> Thanks in advance.
>|||Hi,
In the netbackup script you can mention the database name this script is
used to restore database.
Regards,
Amol Lembhe
"Tom Moreau" wrote:
> Simply restore the database. NetBackup *shouldn't* need to have one already
> there, though I haven't used the product myself.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
> How do I do a restore of a database to another server if I do not create a
> database first?
> "Tom Moreau" wrote:
> > You don't need to create a database before restoring a backup. Chances
> > are
> > you were still connected to that DB while attempting the restore.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> > Hi,
> >
> > We use Veritas NetBackup to do backups and restore of SQL Server 2000
> > databases. Recently, I had to restore a backup of a database to another
> > server for getting some deleted records from the backup. For this I
> > created
> > a
> > new database on the other server with the same name and started a restore
> > with MOVE option from Veritas NetBackup. Even though it was a newly
> > created
> > database on which the restore was being applied, Veritas NetBackup gave an
> > error message that:
> >
> > DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
> > Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> > could
> > not be obtained because the database is in use.>
> >
> > DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> > DATABASE
> > is terminating abnormally.>
> >
> > What could be the reason that Veritas NetBackup wasn't able to get an
> > exclusive access on a newly created database?
> >
> > Thanks in advance.
> >
> >
>|||So, does NetBackup require the existence of the DB before restoring it?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Amol Lembhe" <amolrl@.gmail.com> wrote in message
news:7E73614E-803D-46C0-8714-38A24F048A2C@.microsoft.com...
Hi,
In the netbackup script you can mention the database name this script is
used to restore database.
Regards,
Amol Lembhe
"Tom Moreau" wrote:
> Simply restore the database. NetBackup *shouldn't* need to have one
> already
> there, though I haven't used the product myself.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
> How do I do a restore of a database to another server if I do not create a
> database first?
> "Tom Moreau" wrote:
> > You don't need to create a database before restoring a backup. Chances
> > are
> > you were still connected to that DB while attempting the restore.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> > Hi,
> >
> > We use Veritas NetBackup to do backups and restore of SQL Server 2000
> > databases. Recently, I had to restore a backup of a database to another
> > server for getting some deleted records from the backup. For this I
> > created
> > a
> > new database on the other server with the same name and started a
> > restore
> > with MOVE option from Veritas NetBackup. Even though it was a newly
> > created
> > database on which the restore was being applied, Veritas NetBackup gave
> > an
> > error message that:
> >
> > DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>,
> > Message
> > Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> > could
> > not be obtained because the database is in use.>
> >
> > DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> > DATABASE
> > is terminating abnormally.>
> >
> > What could be the reason that Veritas NetBackup wasn't able to get an
> > exclusive access on a newly created database?
> >
> > Thanks in advance.
> >
> >
>|||No, netbackup does not require DB to be present before restoration.
Regards,
Amol Lembhe
"Tom Moreau" wrote:
> So, does NetBackup require the existence of the DB before restoring it?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Amol Lembhe" <amolrl@.gmail.com> wrote in message
> news:7E73614E-803D-46C0-8714-38A24F048A2C@.microsoft.com...
> Hi,
> In the netbackup script you can mention the database name this script is
> used to restore database.
> Regards,
> Amol Lembhe
>
> "Tom Moreau" wrote:
> > Simply restore the database. NetBackup *shouldn't* need to have one
> > already
> > there, though I haven't used the product myself.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:B700BD9B-A3E9-4D30-AA54-FCB08576E9F0@.microsoft.com...
> > How do I do a restore of a database to another server if I do not create a
> > database first?
> >
> > "Tom Moreau" wrote:
> >
> > > You don't need to create a database before restoring a backup. Chances
> > > are
> > > you were still connected to that DB while attempting the restore.
> > >
> > > --
> > > Tom
> > >
> > > ----
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > > news:7985706F-67EE-45CB-BEE1-22081232E1B6@.microsoft.com...
> > > Hi,
> > >
> > > We use Veritas NetBackup to do backups and restore of SQL Server 2000
> > > databases. Recently, I had to restore a backup of a database to another
> > > server for getting some deleted records from the backup. For this I
> > > created
> > > a
> > > new database on the other server with the same name and started a
> > > restore
> > > with MOVE option from Veritas NetBackup. Even though it was a newly
> > > created
> > > database on which the restore was being applied, Veritas NetBackup gave
> > > an
> > > error message that:
> > >
> > > DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>,
> > > Message
> > > Text <[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
> > > could
> > > not be obtained because the database is in use.>
> > >
> > > DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> > > DATABASE
> > > is terminating abnormally.>
> > >
> > > What could be the reason that Veritas NetBackup wasn't able to get an
> > > exclusive access on a newly created database?
> > >
> > > Thanks in advance.
> > >
> > >
> >
> >
>
Saturday, February 25, 2012
Database Refreshes
Has anyone come across any useful scripts to copy database backups from live
and restore onto dev servers?You are not talking about something like Log Shipping, right?
--
Ekrem Ã?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
and restore onto dev servers?You are not talking about something like Log Shipping, right?
--
Ekrem Ã?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
Database Refreshes
Has anyone come across any useful scripts to copy database backups from live
and restore onto dev servers?
You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?
|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
and restore onto dev servers?
You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?
|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from live
> and restore onto dev servers?
Database Refreshes
Has anyone come across any useful scripts to copy database backups from live
and restore onto dev servers?You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from li
ve
> and restore onto dev servers?
and restore onto dev servers?You are not talking about something like Log Shipping, right?
Ekrem ?nsoy
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:130DBD9F-4CAD-44EC-B804-D2FACC3193F2@.microsoft.com...
> Has anyone come across any useful scripts to copy database backups from
> live
> and restore onto dev servers?|||Take a look at SQL Scripts Automation Central on HTTP://WWW.SQLCOMMUNITY.COM
You'll find few backup scripts that can be used with ease. If you can't find
what you are looking for then request one from main page's "Tell us what you
want?"
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (SQL Server Community)
SQLTips, SQL Forums, SQL Blogs, SQL RADIO, SQL Events, SQL Scripts, SQL
Articles, SQL Clinic and a lot of SQL fun.
"guest5" wrote:
> Has anyone come across any useful scripts to copy database backups from li
ve
> and restore onto dev servers?
Friday, February 24, 2012
Database Recovery Issue
We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
Database Recovery Issue
We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.
There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.
There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
Database Recovery Issue
We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). An
y
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). An
y
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
Subscribe to:
Posts (Atom)