Backup file database was restored from

Hello!
I am trying to find out name of the backup file database was restored from
(I am restoring from DISK), something similar to physical_device_name in
backupmediafamily. restorehistory doesn't have this information.
Any advice is greatly appreciated.
Thanks,
Igor
You can use backup_set_id on restorehistory and media_set_id on backupset to
find the record on backupmediafamily.
Hope this helps,
Ben Nevarez
"Igor Marchenko" wrote:

> Hello!
> I am trying to find out name of the backup file database was restored from
> (I am restoring from DISK), something similar to physical_device_name in
> backupmediafamily. restorehistory doesn't have this information.
> Any advice is greatly appreciated.
> Thanks,
> Igor
|||Thanks a lot Ben! That exactly what I was looking for.
Igor
"Ben Nevarez" wrote:
[vbcol=seagreen]
> You can use backup_set_id on restorehistory and media_set_id on backupset to
> find the record on backupmediafamily.
> Hope this helps,
> Ben Nevarez
>
>
> "Igor Marchenko" wrote:
sql

Backup fails using SMO with big databases

Hello
I'm seeing the backup using SMO fails with big databases (>15GB). I
have a 2GB database and I can see the command go thru. in Profiler but
after it's about 50-70% done, I get an exception saying backup failed.
There is no details on the SQLServer log.

Here's the code snippet:

bk.Initialize = m_backupInit;
bk.PercentCompleteNotification = 10;
bk.PercentComplete += new
PercentCompleteEventHandler(bk_PercentComplete);
bk.SqlBackup(m_Server);

Here's the command as captured by SQL-Profiler:
BACKUP DATABASE [Test_MODEL] TO DISK = N'D:\Temp
\Test_Model_Backup.dat' WITH NOFORMAT, INIT, NOSKIP, REWIND,
NOUNLOAD, STATS = 10

Has anyone else seen this. The wierd thing is it works using old SQL-
DMO.

thanks
SunitOn Feb 8, 11:42 pm, "sjoshi" <sjo...@.ingr.comwrote:

Quote:

Originally Posted by

Hello
I'm seeing the backup using SMO fails with big databases (>15GB). I
have a 2GB database and I can see the command go thru. in Profiler but
after it's about 50-70% done, I get an exception saying backup failed.
There is no details on the SQLServer log.
>
Here's the code snippet:
>
bk.Initialize = m_backupInit;
bk.PercentCompleteNotification = 10;
bk.PercentComplete += new
PercentCompleteEventHandler(bk_PercentComplete);
bk.SqlBackup(m_Server);
>
Here's the command as captured by SQL-Profiler:
BACKUP DATABASE [Test_MODEL] TO DISK = N'D:\Temp
\Test_Model_Backup.dat' WITH NOFORMAT, INIT, NOSKIP, REWIND,
NOUNLOAD, STATS = 10
>
Has anyone else seen this. The wierd thing is it works using old SQL-
DMO.
>
thanks
Sunit

I would check the event log as well, there may more information there.
I have too encountered situations which are similair, however, never
where there was absolutely no information in any of the typical log
locations. 15 gig is not paticulary large, I am sure there must be
more to it. What is the result when you execute via OSQL prompt?
Cheers,
Gsql

Backup error

Hello
I was told by email someone got an backup error and I gotta reply something
to him, what reasons can there be for this error? All services are running
and disk isnt full
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'Backup All Databases'' (0xE09A5EC5A9A4CE4C859FA208632D02D8) - Status:
Failed - Invoked on: 2006-02-17 00:00:00 - Message: The job failed. The Job
was invoked by Schedule 2 (Schedule 1). The last step to run was step 1
(Step 1).There has to be a more detailed error description, this one is telling
you nothing, Look at the particular step of this Maintanance job. As
the maintainance wiurad is creating jobs for all the work which is done
with him, there should be more error descriptions. See if the jobs have
a log purged out, can be found on one tab of the Job step.
HTH, Jens Suessmeyer.|||Jens,
I dont see a step in there, it all looks fine under Database Maintanence
Plans, it's a job that backs up all databases... not sure where to look
<Jens.Suessmeyer@.googlemail.com> wrote in message
news:1140164119.642261.146590@.z14g2000cwz.googlegroups.com...
> There has to be a more detailed error description, this one is telling
> you nothing, Look at the particular step of this Maintanance job. As
> the maintainance wiurad is creating jobs for all the work which is done
> with him, there should be more error descriptions. See if the jobs have
> a log purged out, can be found on one tab of the Job step.
> HTH, Jens Suessmeyer.
>|||Configure the maint plan to create a report file and check that report file
for the actual error
message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Lasse Edsvik" <lasse@.nospam.com> wrote in message news:OFWw7%235MGHA.2580@.TK2MSFTNGP14.phx
.gbl...
> Jens,
> I dont see a step in there, it all looks fine under Database Maintanence
> Plans, it's a job that backs up all databases... not sure where to look
>
> <Jens.Suessmeyer@.googlemail.com> wrote in message
> news:1140164119.642261.146590@.z14g2000cwz.googlegroups.com...
>

Backup and Restore of the Cluster

Hello
I want backup my SQL Server Cluster (two nodes) and to restore it on other
two nodes on another site.
I need to know that procedure to test my DRP. I know that the best would to
have a geocluster but for now (budget limitations) I just want to be able to
restore the cluster.
I would like your help to point me documentation about how to do this
procedure or if someone has any experience about I would be glad to know.
Thanks in advance.
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
Carlos hi,
You will find plenty of information in BOL. Search by planning for disaster
recovery
Also, read the following article and it's links
http://support.microsoft.com/default...b;en-us;307775
HTH
Andreas
"Carlos Eduardo Selonke de Souza" wrote:

> Hello
> I want backup my SQL Server Cluster (two nodes) and to restore it on other
> two nodes on another site.
> I need to know that procedure to test my DRP. I know that the best would to
> have a geocluster but for now (budget limitations) I just want to be able to
> restore the cluster.
> I would like your help to point me documentation about how to do this
> procedure or if someone has any experience about I would be glad to know.
> Thanks in advance.
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org
|||Hello Andreas
Thanks for you repply but Im looking for information about backup and
restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL
Server.
I am most interessed in how to restore the master and msdb database on the
new virtual server, since the user databases is pretty easy.
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
"Andreas Mavrogenis" wrote:
[vbcol=seagreen]
> Carlos hi,
> You will find plenty of information in BOL. Search by planning for disaster
> recovery
> Also, read the following article and it's links
> http://support.microsoft.com/default...b;en-us;307775
> HTH
> Andreas
> "Carlos Eduardo Selonke de Souza" wrote:
|||Hi Carlos,
If you don't have a different instance name, the things that you have to do
are to create your logins to the new server with a DTS Package and after
restoring all your databases, except master, msdb, execute the
sp_change_users_login (Ref. BOL) to assign the roles. Then you will be ready
to check and follow the article below.
http://msdn.microsoft.com/library/de...kprst_4g4w.asp
Please, use them first in a test environment if applicable.
HTH
Andreas
"Carlos Eduardo Selonke de Souza" wrote:
[vbcol=seagreen]
> Hello Andreas
> Thanks for you repply but Im looking for information about backup and
> restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL
> Server.
> I am most interessed in how to restore the master and msdb database on the
> new virtual server, since the user databases is pretty easy.
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org
>
> "Andreas Mavrogenis" wrote:

Backup a database

Hello
I am trying to backup a database, on daily basis.
I wrote script like this:
DECLARE @.mypath = 'C:\Program Files\Microsoft SQL
Server\MSSQL\Backup\ProjectServer' + DATE
BACKUP DATABASE [ProjectServer] TO DISK = @.mypath WITH INIT , NOUNLOAD ,
NAME = N'ProjectServer backup', NOSKIP , STATS = 10, NOFORMAT
It "passed" the "apply" key, but the backup itself failed.
Please advice.It always helps to include the actual error message so we know what we are
dealing with. But I will assume it has to do with your concatenation of the
DATE. You might want to try this instead:
CONVERT(NVARCHAR(16),GETDATE(),112)
Andrew J. Kelly SQL MVP
"Elijah Bass" <elijah.bass@.horizonsemi.com> wrote in message
news:eF1J2$GQGHA.3872@.TK2MSFTNGP15.phx.gbl...
> Hello
> I am trying to backup a database, on daily basis.
> I wrote script like this:
> DECLARE @.mypath = 'C:\Program Files\Microsoft SQL
> Server\MSSQL\Backup\ProjectServer' + DATE
> BACKUP DATABASE [ProjectServer] TO DISK = @.mypath WITH INIT , NOUNLOAD
> , NAME = N'ProjectServer backup', NOSKIP , STATS = 10, NOFORMAT
> It "passed" the "apply" key, but the backup itself failed.
> Please advice.
>|||thank you!
it works
the error was very simple: backup couldnt start:)
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23rh4BmHQGHA.312@.TK2MSFTNGP12.phx.gbl...
> It always helps to include the actual error message so we know what we are
> dealing with. But I will assume it has to do with your concatenation of
> the DATE. You might want to try this instead:
> CONVERT(NVARCHAR(16),GETDATE(),112)
>
> --
> Andrew J. Kelly SQL MVP
>
> "Elijah Bass" <elijah.bass@.horizonsemi.com> wrote in message
> news:eF1J2$GQGHA.3872@.TK2MSFTNGP15.phx.gbl...
>

backing up the model database with BackupExec

Hello:
I used Backup Exec to try to backup a number of databases, including the mod
el database. However, the job failed with the following error message. Any
idea why? Also, if the model database is not part of the backup job, the b
ackup is ok.
An error occurred on a query to filegroup model..PRIMARY.
^ ^ ^ ^ ^
Could not find filegroup 'PRIMARY' in sysfilegroups for database 'model'.
^ ^ ^ ^ ^
Unable to open the item model?PRIMARY - skipped.
Thanks,
JoeHi,
Look into the below post from Microsoft Support for this error: ( I got thsi
from old posts)
When researching this issue, I found one issue where we found that the
customer was performing a full database backup, in addition to filegroup
backups. When a database recovery model is set to simple, we cannot
perform a filegroup backup. As a test, if you have this option set, what
happens when you remove the check for Filegroup backups in your backupexec
User interface?
Thanks
Hari
MCDBA
"Joe Brown" <health_livin@.yahoo.com> wrote in message
news:387823D1-8BC5-479D-9AF7-B0551C04BA7D@.microsoft.com...
> Hello:
> I used Backup Exec to try to backup a number of databases, including the
model database. However, the job failed with the following error message.
Any idea why? Also, if the model database is not part of the backup job,
the backup is ok.
> An error occurred on a query to filegroup model..PRIMARY.
> ^ ^ ^ ^ ^
> Could not find filegroup 'PRIMARY' in sysfilegroups for database 'model'.
> ^ ^ ^ ^ ^
> Unable to open the item model?PRIMARY - skipped.
> Thanks,
> Joe