Can anyone help me out here..I am experimenting with backing up a db using Transact-Sql Backup.
I want to backup the database to a local drive say c:\databaseBk and a remote Server.
I tried
BACKUP DATABASE Mydb TO AlternativeServer but am getting errors here.
I know there is more to it and I also tried as below...
Even backup to remote for now would be perfect...if anyone has the code to do this locally that would be great also...
I got this from BooksOnline.....
USE Mydb
EXEC sp_addumpdevice 'disk', AlternativeServer,
DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mydb.dat'
-- Back up
BACKUP DATABASE MyNwind TO MyNwind_1I've got another one for your collection:
DUMP DATABASE dbname TO device WITH NOUNLOAD , INIT , NOSKIP
Where is the problem lays?
Regards,
OBRP|||As far as I know you can not backup DB on the remote server - only on a local device (tape or drive).|||You can backup on a remote computer by :
backup database dbname to disk='\\remote\server\path\filename.dbk' with init,noskip,NOUNLOAD
This should help you to backup it up to a remote computer without any problem.
Thanks.|||Make sure yours sqlserver runs on domain wide account, or account with write rights on remore compute.
HTH,
OBRP|||Thanks for that...
Showing posts with label drive. Show all posts
Showing posts with label drive. Show all posts
Sunday, March 25, 2012
Thursday, March 22, 2012
Database Backup question
Greetings...
I have a tape drive that my data base it backed up to. I'm running SQL
Server 7 and I backup the entire MSSQL7 folder.
I needed to restore some data in the database. The file was going to
restore was my_database_name.mdf.
Is that the actual database file, and if not, what is?
The reason I ask is because when looking at the file in Windows Explorer,
the date modified was from a week ago, and I know the database has been
modified since then...it changes daily of course.
So basically...if I wanted to back up the database not using the backup in
SQL server, but the one I use for my tape drive, which file or files would I
back up? Any why doesn't the date modified show the current date, since the
database has been modified today?
Thanks
Dan
It's normal that the database file has an old time stamp even it's being
changed actively. The timestamp seems to reflect the time that the file gets
created.
The .mdf file is the data file, not the backup file. you can't restore from
it. You can use sp_attach_db to attach it. If you want to restore, probably
look for a backup file (with or without extension).
HTH.
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||In order to successfully backup your .MDF and .NDF files (data and log),
using the scenario that you posed, you must FIRST stop the MSSQLServer
service. While SQL Server is running, those files will be open and you will
not be able to back them up properly.
Another option is to perform an sp_detachdb and once detached, backup the
data file.
You should really use the Backup features in SQL Server however.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||On Tue, 7 Dec 2004 11:08:39 -0700, "Dan B" <none@.none.com> wrote:
>So basically...if I wanted to back up the database not using the backup in
>SQL server, but the one I use for my tape drive, which file or files would I
>back up?
By default, everything in your PRIMARY filegroup is in the one .mdf
file.
You can set up additional filegroups which are separately restorable.
As usual, see BOL.
J.
I have a tape drive that my data base it backed up to. I'm running SQL
Server 7 and I backup the entire MSSQL7 folder.
I needed to restore some data in the database. The file was going to
restore was my_database_name.mdf.
Is that the actual database file, and if not, what is?
The reason I ask is because when looking at the file in Windows Explorer,
the date modified was from a week ago, and I know the database has been
modified since then...it changes daily of course.
So basically...if I wanted to back up the database not using the backup in
SQL server, but the one I use for my tape drive, which file or files would I
back up? Any why doesn't the date modified show the current date, since the
database has been modified today?
Thanks
Dan
It's normal that the database file has an old time stamp even it's being
changed actively. The timestamp seems to reflect the time that the file gets
created.
The .mdf file is the data file, not the backup file. you can't restore from
it. You can use sp_attach_db to attach it. If you want to restore, probably
look for a backup file (with or without extension).
HTH.
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||In order to successfully backup your .MDF and .NDF files (data and log),
using the scenario that you posed, you must FIRST stop the MSSQLServer
service. While SQL Server is running, those files will be open and you will
not be able to back them up properly.
Another option is to perform an sp_detachdb and once detached, backup the
data file.
You should really use the Backup features in SQL Server however.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||On Tue, 7 Dec 2004 11:08:39 -0700, "Dan B" <none@.none.com> wrote:
>So basically...if I wanted to back up the database not using the backup in
>SQL server, but the one I use for my tape drive, which file or files would I
>back up?
By default, everything in your PRIMARY filegroup is in the one .mdf
file.
You can set up additional filegroups which are separately restorable.
As usual, see BOL.
J.
Database Backup question
Greetings...
I have a tape drive that my data base it backed up to. I'm running SQL
Server 7 and I backup the entire MSSQL7 folder.
I needed to restore some data in the database. The file was going to
restore was my_database_name.mdf.
Is that the actual database file, and if not, what is?
The reason I ask is because when looking at the file in Windows Explorer,
the date modified was from a week ago, and I know the database has been
modified since then...it changes daily of course.
So basically...if I wanted to back up the database not using the backup in
SQL server, but the one I use for my tape drive, which file or files would I
back up? Any why doesn't the date modified show the current date, since the
database has been modified today?
Thanks
Dan
It's normal that the database file has an old time stamp even it's being
changed actively. The timestamp seems to reflect the time that the file gets
created.
The .mdf file is the data file, not the backup file. you can't restore from
it. You can use sp_attach_db to attach it. If you want to restore, probably
look for a backup file (with or without extension).
HTH.
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||In order to successfully backup your .MDF and .NDF files (data and log),
using the scenario that you posed, you must FIRST stop the MSSQLServer
service. While SQL Server is running, those files will be open and you will
not be able to back them up properly.
Another option is to perform an sp_detachdb and once detached, backup the
data file.
You should really use the Backup features in SQL Server however.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||On Tue, 7 Dec 2004 11:08:39 -0700, "Dan B" <none@.none.com> wrote:
>So basically...if I wanted to back up the database not using the backup in
>SQL server, but the one I use for my tape drive, which file or files would I
>back up?
By default, everything in your PRIMARY filegroup is in the one .mdf
file.
You can set up additional filegroups which are separately restorable.
As usual, see BOL.
J.
I have a tape drive that my data base it backed up to. I'm running SQL
Server 7 and I backup the entire MSSQL7 folder.
I needed to restore some data in the database. The file was going to
restore was my_database_name.mdf.
Is that the actual database file, and if not, what is?
The reason I ask is because when looking at the file in Windows Explorer,
the date modified was from a week ago, and I know the database has been
modified since then...it changes daily of course.
So basically...if I wanted to back up the database not using the backup in
SQL server, but the one I use for my tape drive, which file or files would I
back up? Any why doesn't the date modified show the current date, since the
database has been modified today?
Thanks
Dan
It's normal that the database file has an old time stamp even it's being
changed actively. The timestamp seems to reflect the time that the file gets
created.
The .mdf file is the data file, not the backup file. you can't restore from
it. You can use sp_attach_db to attach it. If you want to restore, probably
look for a backup file (with or without extension).
HTH.
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||In order to successfully backup your .MDF and .NDF files (data and log),
using the scenario that you posed, you must FIRST stop the MSSQLServer
service. While SQL Server is running, those files will be open and you will
not be able to back them up properly.
Another option is to perform an sp_detachdb and once detached, backup the
data file.
You should really use the Backup features in SQL Server however.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>
|||On Tue, 7 Dec 2004 11:08:39 -0700, "Dan B" <none@.none.com> wrote:
>So basically...if I wanted to back up the database not using the backup in
>SQL server, but the one I use for my tape drive, which file or files would I
>back up?
By default, everything in your PRIMARY filegroup is in the one .mdf
file.
You can set up additional filegroups which are separately restorable.
As usual, see BOL.
J.
Database Backup question
Greetings...
I have a tape drive that my data base it backed up to. I'm running SQL
Server 7 and I backup the entire MSSQL7 folder.
I needed to restore some data in the database. The file was going to
restore was my_database_name.mdf.
Is that the actual database file, and if not, what is?
The reason I ask is because when looking at the file in Windows Explorer,
the date modified was from a week ago, and I know the database has been
modified since then...it changes daily of course.
So basically...if I wanted to back up the database not using the backup in
SQL server, but the one I use for my tape drive, which file or files would I
back up? Any why doesn't the date modified show the current date, since the
database has been modified today?
Thanks
DanIn order to successfully backup your .MDF and .NDF files (data and log),
using the scenario that you posed, you must FIRST stop the MSSQLServer
service. While SQL Server is running, those files will be open and you will
not be able to back them up properly.
Another option is to perform an sp_detachdb and once detached, backup the
data file.
You should really use the Backup features in SQL Server however.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>|||It's normal that the database file has an old time stamp even it's being
changed actively. The timestamp seems to reflect the time that the file gets
created.
The .mdf file is the data file, not the backup file. you can't restore from
it. You can use sp_attach_db to attach it. If you want to restore, probably
look for a backup file (with or without extension).
HTH.
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>|||On Tue, 7 Dec 2004 11:08:39 -0700, "Dan B" <none@.none.com> wrote:
>So basically...if I wanted to back up the database not using the backup in
>SQL server, but the one I use for my tape drive, which file or files would I
>back up?
By default, everything in your PRIMARY filegroup is in the one .mdf
file.
You can set up additional filegroups which are separately restorable.
As usual, see BOL.
J.
I have a tape drive that my data base it backed up to. I'm running SQL
Server 7 and I backup the entire MSSQL7 folder.
I needed to restore some data in the database. The file was going to
restore was my_database_name.mdf.
Is that the actual database file, and if not, what is?
The reason I ask is because when looking at the file in Windows Explorer,
the date modified was from a week ago, and I know the database has been
modified since then...it changes daily of course.
So basically...if I wanted to back up the database not using the backup in
SQL server, but the one I use for my tape drive, which file or files would I
back up? Any why doesn't the date modified show the current date, since the
database has been modified today?
Thanks
DanIn order to successfully backup your .MDF and .NDF files (data and log),
using the scenario that you posed, you must FIRST stop the MSSQLServer
service. While SQL Server is running, those files will be open and you will
not be able to back them up properly.
Another option is to perform an sp_detachdb and once detached, backup the
data file.
You should really use the Backup features in SQL Server however.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>|||It's normal that the database file has an old time stamp even it's being
changed actively. The timestamp seems to reflect the time that the file gets
created.
The .mdf file is the data file, not the backup file. you can't restore from
it. You can use sp_attach_db to attach it. If you want to restore, probably
look for a backup file (with or without extension).
HTH.
"Dan B" <none@.none.com> wrote in message
news:eLzrIfI3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Greetings...
> I have a tape drive that my data base it backed up to. I'm running SQL
> Server 7 and I backup the entire MSSQL7 folder.
> I needed to restore some data in the database. The file was going to
> restore was my_database_name.mdf.
> Is that the actual database file, and if not, what is?
> The reason I ask is because when looking at the file in Windows Explorer,
> the date modified was from a week ago, and I know the database has been
> modified since then...it changes daily of course.
> So basically...if I wanted to back up the database not using the backup
> in SQL server, but the one I use for my tape drive, which file or files
> would I back up? Any why doesn't the date modified show the current date,
> since the database has been modified today?
> Thanks
> Dan
>|||On Tue, 7 Dec 2004 11:08:39 -0700, "Dan B" <none@.none.com> wrote:
>So basically...if I wanted to back up the database not using the backup in
>SQL server, but the one I use for my tape drive, which file or files would I
>back up?
By default, everything in your PRIMARY filegroup is in the one .mdf
file.
You can set up additional filegroups which are separately restorable.
As usual, see BOL.
J.
Database Backup in SQL Server failover Clustering.
Hi,
I have done MS SQL Server failover clustering with SQL Server 2000
as
One Active node and one Passive Node.
I have set G: drive as a Clustered Drive where Database Files are
placed.
Now i want to take a backup of the database locally on Non-Clustered
Disk .
Is it possible to do this. If yes then please let me know How?
Please give me reply.
Thanks & Regards,
Sajid N. Chhapekar.yes it is possible like any other backup
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > I have done MS SQL Server failover clustering with SQL Server 2000
> > as
> > One Active node and one Passive Node.
> > I have set G: drive as a Clustered Drive where Database Files are
> > placed.
> > Now i want to take a backup of the database locally on Non-Clustered
> > Disk .
> > Is it possible to do this. If yes then please let me know How?
> >
> > Please give me reply.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>> yes it is possible like any other backup
>>
>> "csajid@.gmail.com" wrote:
>> > Hi,
>> >
>> > I have done MS SQL Server failover clustering with SQL Server 2000
>> > as
>> > One Active node and one Passive Node.
>> > I have set G: drive as a Clustered Drive where Database Files are
>> > placed.
>> > Now i want to take a backup of the database locally on Non-Clustered
>> > Disk .
>> > Is it possible to do this. If yes then please let me know How?
>> >
>> > Please give me reply.
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
> > yes it is possible like any other backup
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > as
> > > One Active node and one Passive Node.
> > > I have set G: drive as a Clustered Drive where Database Files are
> > > placed.
> > > Now i want to take a backup of the database locally on Non-Clustered
> > > Disk .
> > > Is it possible to do this. If yes then please let me know How?
> > >
> > > Please give me reply.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > >
> > >
>|||Hi,
Thanks for your reply.
you mean to say that, if my Node goes offline then my backup will
not switch to the
node which is online.
If yes, then is there any way to take a backup on Local disk as my
seniors want to
do this.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> do not use your backup strategy for production.
> if first node go offline, your backup go offline too
> create backup on cluster disk group
> --
> Aleksandar Grbic
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > Thanks for your reply.
> >
> > I have create a backup job which will take a full database backup
> > at 9:00 PM every night.
> > But my concern here is that, the backup will happened on local disk
> > of node which is online but if that node goes offline then the backup
> > will happened on another node which is online or not.
> > this is my please reply to this as it is production issue.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> > Aleksandar Grbic wrote:
> > > yes it is possible like any other backup
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > > as
> > > > One Active node and one Passive Node.
> > > > I have set G: drive as a Clustered Drive where Database Files are
> > > > placed.
> > > > Now i want to take a backup of the database locally on Non-Clustered
> > > > Disk .
> > > > Is it possible to do this. If yes then please let me know How?
> > > >
> > > > Please give me reply.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > >
> > > >
> >
> >|||<csajid@.gmail.com> wrote in message
news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> Hi,
> Thanks for your reply.
> you mean to say that, if my Node goes offline then my backup will
> not switch to the
> node which is online.
> If yes, then is there any way to take a backup on Local disk as my
> seniors want to
> do this.
If the backup job points to say C:\backup, it should always save it to the
local C: drive of the active node.
If you always want it to a specific node, create a share and use the UNC
path: \\node2\backup.
However, I wouldn't do this OR to another disk on the cluster.
I'd backup to a disk on a separate machine. For example, we've got a Snap
4200 that we backup to a UNC on.
> Thanks & Regards,
> Sajid N. Chhapekar.
>
> Aleksandar Grbic wrote:
> > do not use your backup strategy for production.
> > if first node go offline, your backup go offline too
> >
> > create backup on cluster disk group
> > --
> > Aleksandar Grbic
> >
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Thanks for your reply.
> > >
> > > I have create a backup job which will take a full database backup
> > > at 9:00 PM every night.
> > > But my concern here is that, the backup will happened on local
disk
> > > of node which is online but if that node goes offline then the backup
> > > will happened on another node which is online or not.
> > > this is my please reply to this as it is production issue.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > > Aleksandar Grbic wrote:
> > > > yes it is possible like any other backup
> > > >
> > > >
> > > > "csajid@.gmail.com" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I have done MS SQL Server failover clustering with SQL Server
2000
> > > > > as
> > > > > One Active node and one Passive Node.
> > > > > I have set G: drive as a Clustered Drive where Database Files
are
> > > > > placed.
> > > > > Now i want to take a backup of the database locally on
Non-Clustered
> > > > > Disk .
> > > > > Is it possible to do this. If yes then please let me know How?
> > > > >
> > > > > Please give me reply.
> > > > >
> > > > > Thanks & Regards,
> > > > > Sajid N. Chhapekar.
> > > > >
> > > > >
> > >
> > >
>|||Hi,
Thanks for your reply.
Now, i try to make it more simple.
I have to nodes in a Active/Passive Cluster.
Where node A is Passive and Node B is Active.
I have same drive on both the nodes that is, C: D: E: Q: and G:
where G: is clustered
disk & Of course here Q: is Quorum disk.
Here i schedule daily backup on E: drive, which is same location
on both the nodes.
as my node B is active the backup is pointing to E: drive of node
B.
Now my point here is if my node B becomes Passive and node A
active then backup
will point to E: drive of Node A or it fails.
Thanks & Regards,
Sajid N.Chhapekar.
Greg D. Moore (Strider) wrote:
> <csajid@.gmail.com> wrote in message
> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> > you mean to say that, if my Node goes offline then my backup will
> > not switch to the
> > node which is online.
> > If yes, then is there any way to take a backup on Local disk as my
> > seniors want to
> > do this.
> If the backup job points to say C:\backup, it should always save it to the
> local C: drive of the active node.
> If you always want it to a specific node, create a share and use the UNC
> path: \\node2\backup.
> However, I wouldn't do this OR to another disk on the cluster.
> I'd backup to a disk on a separate machine. For example, we've got a Snap
> 4200 that we backup to a UNC on.
>
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >
> > Aleksandar Grbic wrote:
> > > do not use your backup strategy for production.
> > > if first node go offline, your backup go offline too
> > >
> > > create backup on cluster disk group
> > > --
> > > Aleksandar Grbic
> > >
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > Thanks for your reply.
> > > >
> > > > I have create a backup job which will take a full database backup
> > > > at 9:00 PM every night.
> > > > But my concern here is that, the backup will happened on local
> disk
> > > > of node which is online but if that node goes offline then the backup
> > > > will happened on another node which is online or not.
> > > > this is my please reply to this as it is production issue.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > > Aleksandar Grbic wrote:
> > > > > yes it is possible like any other backup
> > > > >
> > > > >
> > > > > "csajid@.gmail.com" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I have done MS SQL Server failover clustering with SQL Server
> 2000
> > > > > > as
> > > > > > One Active node and one Passive Node.
> > > > > > I have set G: drive as a Clustered Drive where Database Files
> are
> > > > > > placed.
> > > > > > Now i want to take a backup of the database locally on
> Non-Clustered
> > > > > > Disk .
> > > > > > Is it possible to do this. If yes then please let me know How?
> > > > > >
> > > > > > Please give me reply.
> > > > > >
> > > > > > Thanks & Regards,
> > > > > > Sajid N. Chhapekar.
> > > > > >
> > > > > >
> > > >
> > > >
> >|||You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
local disk which exists on both node A and B. The backups will work fine, and store the backup file
on the local drive (which one depends on what node is the active node). The database engine doesn't
really know or care whether it is clustered, it just sees a number of drives.
But here's a scenario which might make you re-consider:
Node A does backup locally.
It then fails, and you also have to do a restore.
Node B is started and you cannot get to the backup file produced by node A, because that node has
failed and stored the backup locally.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> Now, i try to make it more simple.
> I have to nodes in a Active/Passive Cluster.
> Where node A is Passive and Node B is Active.
> I have same drive on both the nodes that is, C: D: E: Q: and G:
> where G: is clustered
> disk & Of course here Q: is Quorum disk.
> Here i schedule daily backup on E: drive, which is same location
> on both the nodes.
> as my node B is active the backup is pointing to E: drive of node
> B.
> Now my point here is if my node B becomes Passive and node A
> active then backup
> will point to E: drive of Node A or it fails.
> Thanks & Regards,
> Sajid N.Chhapekar.
> Greg D. Moore (Strider) wrote:
>> <csajid@.gmail.com> wrote in message
>> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
>> > Hi,
>> >
>> > Thanks for your reply.
>> > you mean to say that, if my Node goes offline then my backup will
>> > not switch to the
>> > node which is online.
>> > If yes, then is there any way to take a backup on Local disk as my
>> > seniors want to
>> > do this.
>> If the backup job points to say C:\backup, it should always save it to the
>> local C: drive of the active node.
>> If you always want it to a specific node, create a share and use the UNC
>> path: \\node2\backup.
>> However, I wouldn't do this OR to another disk on the cluster.
>> I'd backup to a disk on a separate machine. For example, we've got a Snap
>> 4200 that we backup to a UNC on.
>>
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>> > Aleksandar Grbic wrote:
>> > > do not use your backup strategy for production.
>> > > if first node go offline, your backup go offline too
>> > >
>> > > create backup on cluster disk group
>> > > --
>> > > Aleksandar Grbic
>> > >
>> > >
>> > >
>> > > "csajid@.gmail.com" wrote:
>> > >
>> > > > Hi,
>> > > >
>> > > > Thanks for your reply.
>> > > >
>> > > > I have create a backup job which will take a full database backup
>> > > > at 9:00 PM every night.
>> > > > But my concern here is that, the backup will happened on local
>> disk
>> > > > of node which is online but if that node goes offline then the backup
>> > > > will happened on another node which is online or not.
>> > > > this is my please reply to this as it is production issue.
>> > > >
>> > > > Thanks & Regards,
>> > > > Sajid N. Chhapekar.
>> > > > Aleksandar Grbic wrote:
>> > > > > yes it is possible like any other backup
>> > > > >
>> > > > >
>> > > > > "csajid@.gmail.com" wrote:
>> > > > >
>> > > > > > Hi,
>> > > > > >
>> > > > > > I have done MS SQL Server failover clustering with SQL Server
>> 2000
>> > > > > > as
>> > > > > > One Active node and one Passive Node.
>> > > > > > I have set G: drive as a Clustered Drive where Database Files
>> are
>> > > > > > placed.
>> > > > > > Now i want to take a backup of the database locally on
>> Non-Clustered
>> > > > > > Disk .
>> > > > > > Is it possible to do this. If yes then please let me know How?
>> > > > > >
>> > > > > > Please give me reply.
>> > > > > >
>> > > > > > Thanks & Regards,
>> > > > > > Sajid N. Chhapekar.
>> > > > > >
>> > > > > >
>> > > >
>> > > >
>> >
>|||Hi,
Thanks for reply.
I understand what u are trying to say.
In this case, as we have windows backup stratergy which backup the
the folder where backup file is stored.
So, that if one node fails where backup file is stored, we can get
it from backup tape.
Thanks & Regards,
Sajid N. Chhapekar.
Tibor Karaszi wrote:
> You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
> local disk which exists on both node A and B. The backups will work fine, and store the backup file
> on the local drive (which one depends on what node is the active node). The database engine doesn't
> really know or care whether it is clustered, it just sees a number of drives.
> But here's a scenario which might make you re-consider:
> Node A does backup locally.
> It then fails, and you also have to do a restore.
> Node B is started and you cannot get to the backup file produced by node A, because that node has
> failed and stored the backup locally.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> >
> > Now, i try to make it more simple.
> > I have to nodes in a Active/Passive Cluster.
> > Where node A is Passive and Node B is Active.
> > I have same drive on both the nodes that is, C: D: E: Q: and G:
> > where G: is clustered
> > disk & Of course here Q: is Quorum disk.
> > Here i schedule daily backup on E: drive, which is same location
> > on both the nodes.
> > as my node B is active the backup is pointing to E: drive of node
> > B.
> > Now my point here is if my node B becomes Passive and node A
> > active then backup
> > will point to E: drive of Node A or it fails.
> >
> > Thanks & Regards,
> > Sajid N.Chhapekar.
> >
> > Greg D. Moore (Strider) wrote:
> >> <csajid@.gmail.com> wrote in message
> >> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> >> > Hi,
> >> >
> >> > Thanks for your reply.
> >> > you mean to say that, if my Node goes offline then my backup will
> >> > not switch to the
> >> > node which is online.
> >> > If yes, then is there any way to take a backup on Local disk as my
> >> > seniors want to
> >> > do this.
> >>
> >> If the backup job points to say C:\backup, it should always save it to the
> >> local C: drive of the active node.
> >>
> >> If you always want it to a specific node, create a share and use the UNC
> >> path: \\node2\backup.
> >>
> >> However, I wouldn't do this OR to another disk on the cluster.
> >>
> >> I'd backup to a disk on a separate machine. For example, we've got a Snap
> >> 4200 that we backup to a UNC on.
> >>
> >>
> >> >
> >> > Thanks & Regards,
> >> > Sajid N. Chhapekar.
> >> >
> >> >
> >> > Aleksandar Grbic wrote:
> >> > > do not use your backup strategy for production.
> >> > > if first node go offline, your backup go offline too
> >> > >
> >> > > create backup on cluster disk group
> >> > > --
> >> > > Aleksandar Grbic
> >> > >
> >> > >
> >> > >
> >> > > "csajid@.gmail.com" wrote:
> >> > >
> >> > > > Hi,
> >> > > >
> >> > > > Thanks for your reply.
> >> > > >
> >> > > > I have create a backup job which will take a full database backup
> >> > > > at 9:00 PM every night.
> >> > > > But my concern here is that, the backup will happened on local
> >> disk
> >> > > > of node which is online but if that node goes offline then the backup
> >> > > > will happened on another node which is online or not.
> >> > > > this is my please reply to this as it is production issue.
> >> > > >
> >> > > > Thanks & Regards,
> >> > > > Sajid N. Chhapekar.
> >> > > > Aleksandar Grbic wrote:
> >> > > > > yes it is possible like any other backup
> >> > > > >
> >> > > > >
> >> > > > > "csajid@.gmail.com" wrote:
> >> > > > >
> >> > > > > > Hi,
> >> > > > > >
> >> > > > > > I have done MS SQL Server failover clustering with SQL Server
> >> 2000
> >> > > > > > as
> >> > > > > > One Active node and one Passive Node.
> >> > > > > > I have set G: drive as a Clustered Drive where Database Files
> >> are
> >> > > > > > placed.
> >> > > > > > Now i want to take a backup of the database locally on
> >> Non-Clustered
> >> > > > > > Disk .
> >> > > > > > Is it possible to do this. If yes then please let me know How?
> >> > > > > >
> >> > > > > > Please give me reply.
> >> > > > > >
> >> > > > > > Thanks & Regards,
> >> > > > > > Sajid N. Chhapekar.
> >> > > > > >
> >> > > > > >
> >> > > >
> >> > > >
> >> >
> >
I have done MS SQL Server failover clustering with SQL Server 2000
as
One Active node and one Passive Node.
I have set G: drive as a Clustered Drive where Database Files are
placed.
Now i want to take a backup of the database locally on Non-Clustered
Disk .
Is it possible to do this. If yes then please let me know How?
Please give me reply.
Thanks & Regards,
Sajid N. Chhapekar.yes it is possible like any other backup
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > I have done MS SQL Server failover clustering with SQL Server 2000
> > as
> > One Active node and one Passive Node.
> > I have set G: drive as a Clustered Drive where Database Files are
> > placed.
> > Now i want to take a backup of the database locally on Non-Clustered
> > Disk .
> > Is it possible to do this. If yes then please let me know How?
> >
> > Please give me reply.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>> yes it is possible like any other backup
>>
>> "csajid@.gmail.com" wrote:
>> > Hi,
>> >
>> > I have done MS SQL Server failover clustering with SQL Server 2000
>> > as
>> > One Active node and one Passive Node.
>> > I have set G: drive as a Clustered Drive where Database Files are
>> > placed.
>> > Now i want to take a backup of the database locally on Non-Clustered
>> > Disk .
>> > Is it possible to do this. If yes then please let me know How?
>> >
>> > Please give me reply.
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
> > yes it is possible like any other backup
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > as
> > > One Active node and one Passive Node.
> > > I have set G: drive as a Clustered Drive where Database Files are
> > > placed.
> > > Now i want to take a backup of the database locally on Non-Clustered
> > > Disk .
> > > Is it possible to do this. If yes then please let me know How?
> > >
> > > Please give me reply.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > >
> > >
>|||Hi,
Thanks for your reply.
you mean to say that, if my Node goes offline then my backup will
not switch to the
node which is online.
If yes, then is there any way to take a backup on Local disk as my
seniors want to
do this.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> do not use your backup strategy for production.
> if first node go offline, your backup go offline too
> create backup on cluster disk group
> --
> Aleksandar Grbic
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > Thanks for your reply.
> >
> > I have create a backup job which will take a full database backup
> > at 9:00 PM every night.
> > But my concern here is that, the backup will happened on local disk
> > of node which is online but if that node goes offline then the backup
> > will happened on another node which is online or not.
> > this is my please reply to this as it is production issue.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> > Aleksandar Grbic wrote:
> > > yes it is possible like any other backup
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > > as
> > > > One Active node and one Passive Node.
> > > > I have set G: drive as a Clustered Drive where Database Files are
> > > > placed.
> > > > Now i want to take a backup of the database locally on Non-Clustered
> > > > Disk .
> > > > Is it possible to do this. If yes then please let me know How?
> > > >
> > > > Please give me reply.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > >
> > > >
> >
> >|||<csajid@.gmail.com> wrote in message
news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> Hi,
> Thanks for your reply.
> you mean to say that, if my Node goes offline then my backup will
> not switch to the
> node which is online.
> If yes, then is there any way to take a backup on Local disk as my
> seniors want to
> do this.
If the backup job points to say C:\backup, it should always save it to the
local C: drive of the active node.
If you always want it to a specific node, create a share and use the UNC
path: \\node2\backup.
However, I wouldn't do this OR to another disk on the cluster.
I'd backup to a disk on a separate machine. For example, we've got a Snap
4200 that we backup to a UNC on.
> Thanks & Regards,
> Sajid N. Chhapekar.
>
> Aleksandar Grbic wrote:
> > do not use your backup strategy for production.
> > if first node go offline, your backup go offline too
> >
> > create backup on cluster disk group
> > --
> > Aleksandar Grbic
> >
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Thanks for your reply.
> > >
> > > I have create a backup job which will take a full database backup
> > > at 9:00 PM every night.
> > > But my concern here is that, the backup will happened on local
disk
> > > of node which is online but if that node goes offline then the backup
> > > will happened on another node which is online or not.
> > > this is my please reply to this as it is production issue.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > > Aleksandar Grbic wrote:
> > > > yes it is possible like any other backup
> > > >
> > > >
> > > > "csajid@.gmail.com" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I have done MS SQL Server failover clustering with SQL Server
2000
> > > > > as
> > > > > One Active node and one Passive Node.
> > > > > I have set G: drive as a Clustered Drive where Database Files
are
> > > > > placed.
> > > > > Now i want to take a backup of the database locally on
Non-Clustered
> > > > > Disk .
> > > > > Is it possible to do this. If yes then please let me know How?
> > > > >
> > > > > Please give me reply.
> > > > >
> > > > > Thanks & Regards,
> > > > > Sajid N. Chhapekar.
> > > > >
> > > > >
> > >
> > >
>|||Hi,
Thanks for your reply.
Now, i try to make it more simple.
I have to nodes in a Active/Passive Cluster.
Where node A is Passive and Node B is Active.
I have same drive on both the nodes that is, C: D: E: Q: and G:
where G: is clustered
disk & Of course here Q: is Quorum disk.
Here i schedule daily backup on E: drive, which is same location
on both the nodes.
as my node B is active the backup is pointing to E: drive of node
B.
Now my point here is if my node B becomes Passive and node A
active then backup
will point to E: drive of Node A or it fails.
Thanks & Regards,
Sajid N.Chhapekar.
Greg D. Moore (Strider) wrote:
> <csajid@.gmail.com> wrote in message
> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> > you mean to say that, if my Node goes offline then my backup will
> > not switch to the
> > node which is online.
> > If yes, then is there any way to take a backup on Local disk as my
> > seniors want to
> > do this.
> If the backup job points to say C:\backup, it should always save it to the
> local C: drive of the active node.
> If you always want it to a specific node, create a share and use the UNC
> path: \\node2\backup.
> However, I wouldn't do this OR to another disk on the cluster.
> I'd backup to a disk on a separate machine. For example, we've got a Snap
> 4200 that we backup to a UNC on.
>
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >
> > Aleksandar Grbic wrote:
> > > do not use your backup strategy for production.
> > > if first node go offline, your backup go offline too
> > >
> > > create backup on cluster disk group
> > > --
> > > Aleksandar Grbic
> > >
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > Thanks for your reply.
> > > >
> > > > I have create a backup job which will take a full database backup
> > > > at 9:00 PM every night.
> > > > But my concern here is that, the backup will happened on local
> disk
> > > > of node which is online but if that node goes offline then the backup
> > > > will happened on another node which is online or not.
> > > > this is my please reply to this as it is production issue.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > > Aleksandar Grbic wrote:
> > > > > yes it is possible like any other backup
> > > > >
> > > > >
> > > > > "csajid@.gmail.com" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I have done MS SQL Server failover clustering with SQL Server
> 2000
> > > > > > as
> > > > > > One Active node and one Passive Node.
> > > > > > I have set G: drive as a Clustered Drive where Database Files
> are
> > > > > > placed.
> > > > > > Now i want to take a backup of the database locally on
> Non-Clustered
> > > > > > Disk .
> > > > > > Is it possible to do this. If yes then please let me know How?
> > > > > >
> > > > > > Please give me reply.
> > > > > >
> > > > > > Thanks & Regards,
> > > > > > Sajid N. Chhapekar.
> > > > > >
> > > > > >
> > > >
> > > >
> >|||You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
local disk which exists on both node A and B. The backups will work fine, and store the backup file
on the local drive (which one depends on what node is the active node). The database engine doesn't
really know or care whether it is clustered, it just sees a number of drives.
But here's a scenario which might make you re-consider:
Node A does backup locally.
It then fails, and you also have to do a restore.
Node B is started and you cannot get to the backup file produced by node A, because that node has
failed and stored the backup locally.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> Now, i try to make it more simple.
> I have to nodes in a Active/Passive Cluster.
> Where node A is Passive and Node B is Active.
> I have same drive on both the nodes that is, C: D: E: Q: and G:
> where G: is clustered
> disk & Of course here Q: is Quorum disk.
> Here i schedule daily backup on E: drive, which is same location
> on both the nodes.
> as my node B is active the backup is pointing to E: drive of node
> B.
> Now my point here is if my node B becomes Passive and node A
> active then backup
> will point to E: drive of Node A or it fails.
> Thanks & Regards,
> Sajid N.Chhapekar.
> Greg D. Moore (Strider) wrote:
>> <csajid@.gmail.com> wrote in message
>> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
>> > Hi,
>> >
>> > Thanks for your reply.
>> > you mean to say that, if my Node goes offline then my backup will
>> > not switch to the
>> > node which is online.
>> > If yes, then is there any way to take a backup on Local disk as my
>> > seniors want to
>> > do this.
>> If the backup job points to say C:\backup, it should always save it to the
>> local C: drive of the active node.
>> If you always want it to a specific node, create a share and use the UNC
>> path: \\node2\backup.
>> However, I wouldn't do this OR to another disk on the cluster.
>> I'd backup to a disk on a separate machine. For example, we've got a Snap
>> 4200 that we backup to a UNC on.
>>
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>> > Aleksandar Grbic wrote:
>> > > do not use your backup strategy for production.
>> > > if first node go offline, your backup go offline too
>> > >
>> > > create backup on cluster disk group
>> > > --
>> > > Aleksandar Grbic
>> > >
>> > >
>> > >
>> > > "csajid@.gmail.com" wrote:
>> > >
>> > > > Hi,
>> > > >
>> > > > Thanks for your reply.
>> > > >
>> > > > I have create a backup job which will take a full database backup
>> > > > at 9:00 PM every night.
>> > > > But my concern here is that, the backup will happened on local
>> disk
>> > > > of node which is online but if that node goes offline then the backup
>> > > > will happened on another node which is online or not.
>> > > > this is my please reply to this as it is production issue.
>> > > >
>> > > > Thanks & Regards,
>> > > > Sajid N. Chhapekar.
>> > > > Aleksandar Grbic wrote:
>> > > > > yes it is possible like any other backup
>> > > > >
>> > > > >
>> > > > > "csajid@.gmail.com" wrote:
>> > > > >
>> > > > > > Hi,
>> > > > > >
>> > > > > > I have done MS SQL Server failover clustering with SQL Server
>> 2000
>> > > > > > as
>> > > > > > One Active node and one Passive Node.
>> > > > > > I have set G: drive as a Clustered Drive where Database Files
>> are
>> > > > > > placed.
>> > > > > > Now i want to take a backup of the database locally on
>> Non-Clustered
>> > > > > > Disk .
>> > > > > > Is it possible to do this. If yes then please let me know How?
>> > > > > >
>> > > > > > Please give me reply.
>> > > > > >
>> > > > > > Thanks & Regards,
>> > > > > > Sajid N. Chhapekar.
>> > > > > >
>> > > > > >
>> > > >
>> > > >
>> >
>|||Hi,
Thanks for reply.
I understand what u are trying to say.
In this case, as we have windows backup stratergy which backup the
the folder where backup file is stored.
So, that if one node fails where backup file is stored, we can get
it from backup tape.
Thanks & Regards,
Sajid N. Chhapekar.
Tibor Karaszi wrote:
> You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
> local disk which exists on both node A and B. The backups will work fine, and store the backup file
> on the local drive (which one depends on what node is the active node). The database engine doesn't
> really know or care whether it is clustered, it just sees a number of drives.
> But here's a scenario which might make you re-consider:
> Node A does backup locally.
> It then fails, and you also have to do a restore.
> Node B is started and you cannot get to the backup file produced by node A, because that node has
> failed and stored the backup locally.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> >
> > Now, i try to make it more simple.
> > I have to nodes in a Active/Passive Cluster.
> > Where node A is Passive and Node B is Active.
> > I have same drive on both the nodes that is, C: D: E: Q: and G:
> > where G: is clustered
> > disk & Of course here Q: is Quorum disk.
> > Here i schedule daily backup on E: drive, which is same location
> > on both the nodes.
> > as my node B is active the backup is pointing to E: drive of node
> > B.
> > Now my point here is if my node B becomes Passive and node A
> > active then backup
> > will point to E: drive of Node A or it fails.
> >
> > Thanks & Regards,
> > Sajid N.Chhapekar.
> >
> > Greg D. Moore (Strider) wrote:
> >> <csajid@.gmail.com> wrote in message
> >> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> >> > Hi,
> >> >
> >> > Thanks for your reply.
> >> > you mean to say that, if my Node goes offline then my backup will
> >> > not switch to the
> >> > node which is online.
> >> > If yes, then is there any way to take a backup on Local disk as my
> >> > seniors want to
> >> > do this.
> >>
> >> If the backup job points to say C:\backup, it should always save it to the
> >> local C: drive of the active node.
> >>
> >> If you always want it to a specific node, create a share and use the UNC
> >> path: \\node2\backup.
> >>
> >> However, I wouldn't do this OR to another disk on the cluster.
> >>
> >> I'd backup to a disk on a separate machine. For example, we've got a Snap
> >> 4200 that we backup to a UNC on.
> >>
> >>
> >> >
> >> > Thanks & Regards,
> >> > Sajid N. Chhapekar.
> >> >
> >> >
> >> > Aleksandar Grbic wrote:
> >> > > do not use your backup strategy for production.
> >> > > if first node go offline, your backup go offline too
> >> > >
> >> > > create backup on cluster disk group
> >> > > --
> >> > > Aleksandar Grbic
> >> > >
> >> > >
> >> > >
> >> > > "csajid@.gmail.com" wrote:
> >> > >
> >> > > > Hi,
> >> > > >
> >> > > > Thanks for your reply.
> >> > > >
> >> > > > I have create a backup job which will take a full database backup
> >> > > > at 9:00 PM every night.
> >> > > > But my concern here is that, the backup will happened on local
> >> disk
> >> > > > of node which is online but if that node goes offline then the backup
> >> > > > will happened on another node which is online or not.
> >> > > > this is my please reply to this as it is production issue.
> >> > > >
> >> > > > Thanks & Regards,
> >> > > > Sajid N. Chhapekar.
> >> > > > Aleksandar Grbic wrote:
> >> > > > > yes it is possible like any other backup
> >> > > > >
> >> > > > >
> >> > > > > "csajid@.gmail.com" wrote:
> >> > > > >
> >> > > > > > Hi,
> >> > > > > >
> >> > > > > > I have done MS SQL Server failover clustering with SQL Server
> >> 2000
> >> > > > > > as
> >> > > > > > One Active node and one Passive Node.
> >> > > > > > I have set G: drive as a Clustered Drive where Database Files
> >> are
> >> > > > > > placed.
> >> > > > > > Now i want to take a backup of the database locally on
> >> Non-Clustered
> >> > > > > > Disk .
> >> > > > > > Is it possible to do this. If yes then please let me know How?
> >> > > > > >
> >> > > > > > Please give me reply.
> >> > > > > >
> >> > > > > > Thanks & Regards,
> >> > > > > > Sajid N. Chhapekar.
> >> > > > > >
> >> > > > > >
> >> > > >
> >> > > >
> >> >
> >
Monday, March 19, 2012
Database Attach Help!
Due to space issues we had to detach one of our databases. It stopped
working because the drive ran out of space. We have moved the .mdf and the
..ldf to another drive with much more space. When I try to attach I get the
following?
Error 3624
74 transactions rolled forward in database
2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
line=1920
Failed Assertion = 'IsValidSlot (sid)'.
2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
I believe that the transaction lof is corrupt. I there a way to clear the
transaction log and then re-attach?
Any other ideas allso welcome.
Thank you
Paul
I am surprised that you have X transactions rolled forward if you detached the database... You could
try sp_single_file_attach and see if that work with only the mdf file. If not, I suggest you open a
case with MS support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Glickenhaus" <PaulGlickenhaus@.discussions.microsoft.com> wrote in message
news:A957BF1E-7448-4363-8A23-6F8937C95CF9@.microsoft.com...
> Due to space issues we had to detach one of our databases. It stopped
> working because the drive ran out of space. We have moved the .mdf and the
> .ldf to another drive with much more space. When I try to attach I get the
> following?
> Error 3624
> 74 transactions rolled forward in database
> 2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
> line=1920
> Failed Assertion = 'IsValidSlot (sid)'.
> 2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
> 2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
>
> I believe that the transaction lof is corrupt. I there a way to clear the
> transaction log and then re-attach?
> Any other ideas allso welcome.
> Thank you
> Paul
>
working because the drive ran out of space. We have moved the .mdf and the
..ldf to another drive with much more space. When I try to attach I get the
following?
Error 3624
74 transactions rolled forward in database
2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
line=1920
Failed Assertion = 'IsValidSlot (sid)'.
2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
I believe that the transaction lof is corrupt. I there a way to clear the
transaction log and then re-attach?
Any other ideas allso welcome.
Thank you
Paul
I am surprised that you have X transactions rolled forward if you detached the database... You could
try sp_single_file_attach and see if that work with only the mdf file. If not, I suggest you open a
case with MS support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Glickenhaus" <PaulGlickenhaus@.discussions.microsoft.com> wrote in message
news:A957BF1E-7448-4363-8A23-6F8937C95CF9@.microsoft.com...
> Due to space issues we had to detach one of our databases. It stopped
> working because the drive ran out of space. We have moved the .mdf and the
> .ldf to another drive with much more space. When I try to attach I get the
> following?
> Error 3624
> 74 transactions rolled forward in database
> 2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
> line=1920
> Failed Assertion = 'IsValidSlot (sid)'.
> 2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
> 2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
>
> I believe that the transaction lof is corrupt. I there a way to clear the
> transaction log and then re-attach?
> Any other ideas allso welcome.
> Thank you
> Paul
>
Database Attach Help!
Due to space issues we had to detach one of our databases. It stopped
working because the drive ran out of space. We have moved the .mdf and the
.ldf to another drive with much more space. When I try to attach I get the
following?
Error 3624
74 transactions rolled forward in database
2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
line=1920
Failed Assertion = 'IsValidSlot (sid)'.
2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
I believe that the transaction lof is corrupt. I there a way to clear the
transaction log and then re-attach?
Any other ideas allso welcome.
Thank you
PaulI am surprised that you have X transactions rolled forward if you detached t
he database... You could
try sp_single_file_attach and see if that work with only the mdf file. If no
t, I suggest you open a
case with MS support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Glickenhaus" <PaulGlickenhaus@.discussions.microsoft.com> wrote in mess
age
news:A957BF1E-7448-4363-8A23-6F8937C95CF9@.microsoft.com...
> Due to space issues we had to detach one of our databases. It stopped
> working because the drive ran out of space. We have moved the .mdf and th
e
> .ldf to another drive with much more space. When I try to attach I get th
e
> following?
> Error 3624
> 74 transactions rolled forward in database
> 2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
> line=1920
> Failed Assertion = 'IsValidSlot (sid)'.
> 2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
> 2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
>
> I believe that the transaction lof is corrupt. I there a way to clear the
> transaction log and then re-attach?
> Any other ideas allso welcome.
> Thank you
> Paul
>
working because the drive ran out of space. We have moved the .mdf and the
.ldf to another drive with much more space. When I try to attach I get the
following?
Error 3624
74 transactions rolled forward in database
2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
line=1920
Failed Assertion = 'IsValidSlot (sid)'.
2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
I believe that the transaction lof is corrupt. I there a way to clear the
transaction log and then re-attach?
Any other ideas allso welcome.
Thank you
PaulI am surprised that you have X transactions rolled forward if you detached t
he database... You could
try sp_single_file_attach and see if that work with only the mdf file. If no
t, I suggest you open a
case with MS support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Glickenhaus" <PaulGlickenhaus@.discussions.microsoft.com> wrote in mess
age
news:A957BF1E-7448-4363-8A23-6F8937C95CF9@.microsoft.com...
> Due to space issues we had to detach one of our databases. It stopped
> working because the drive ran out of space. We have moved the .mdf and th
e
> .ldf to another drive with much more space. When I try to attach I get th
e
> following?
> Error 3624
> 74 transactions rolled forward in database
> 2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
> line=1920
> Failed Assertion = 'IsValidSlot (sid)'.
> 2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
> 2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
>
> I believe that the transaction lof is corrupt. I there a way to clear the
> transaction log and then re-attach?
> Any other ideas allso welcome.
> Thank you
> Paul
>
Database Attach Help!
Due to space issues we had to detach one of our databases. It stopped
working because the drive ran out of space. We have moved the .mdf and the
.ldf to another drive with much more space. When I try to attach I get the
following?
Error 3624
74 transactions rolled forward in database
2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
line=1920
Failed Assertion = 'IsValidSlot (sid)'.
2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
I believe that the transaction lof is corrupt. I there a way to clear the
transaction log and then re-attach?
Any other ideas allso welcome.
Thank you
PaulI am surprised that you have X transactions rolled forward if you detached the database... You could
try sp_single_file_attach and see if that work with only the mdf file. If not, I suggest you open a
case with MS support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Glickenhaus" <PaulGlickenhaus@.discussions.microsoft.com> wrote in message
news:A957BF1E-7448-4363-8A23-6F8937C95CF9@.microsoft.com...
> Due to space issues we had to detach one of our databases. It stopped
> working because the drive ran out of space. We have moved the .mdf and the
> .ldf to another drive with much more space. When I try to attach I get the
> following?
> Error 3624
> 74 transactions rolled forward in database
> 2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
> line=1920
> Failed Assertion = 'IsValidSlot (sid)'.
> 2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
> 2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
>
> I believe that the transaction lof is corrupt. I there a way to clear the
> transaction log and then re-attach?
> Any other ideas allso welcome.
> Thank you
> Paul
>
working because the drive ran out of space. We have moved the .mdf and the
.ldf to another drive with much more space. When I try to attach I get the
following?
Error 3624
74 transactions rolled forward in database
2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
line=1920
Failed Assertion = 'IsValidSlot (sid)'.
2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
I believe that the transaction lof is corrupt. I there a way to clear the
transaction log and then re-attach?
Any other ideas allso welcome.
Thank you
PaulI am surprised that you have X transactions rolled forward if you detached the database... You could
try sp_single_file_attach and see if that work with only the mdf file. If not, I suggest you open a
case with MS support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Glickenhaus" <PaulGlickenhaus@.discussions.microsoft.com> wrote in message
news:A957BF1E-7448-4363-8A23-6F8937C95CF9@.microsoft.com...
> Due to space issues we had to detach one of our databases. It stopped
> working because the drive ran out of space. We have moved the .mdf and the
> .ldf to another drive with much more space. When I try to attach I get the
> following?
> Error 3624
> 74 transactions rolled forward in database
> 2006-09-22 12:07:49.53 spid53 SQL Server Assertion: File: <page.cpp>,
> line=1920
> Failed Assertion = 'IsValidSlot (sid)'.
> 2006-09-22 12:07:49.53 spid53 Error: 3624, Severity: 20, State: 1.
> 2006-09-22 12:07:49.53 spid53 Error: 3314, Severity: 21, State: 3
>
> I believe that the transaction lof is corrupt. I there a way to clear the
> transaction log and then re-attach?
> Any other ideas allso welcome.
> Thank you
> Paul
>
Database Attach error encountered
Would appreciate any inputs.
I am running SQL2005. I am trying to attach to a database located on an external hard drive that is connected to my laptop via USB connection. The database files are a copy of the database files from a server running SQL2005.
After making the copy of the database, we confirmed that we could attach to the database on the external drive from the server and were successful attaching, opening and accessing the copy. Brought the HD home to work with the database and am getting the following error when I try to attach:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.GetOriginalDatabaseName(String primaryFilePath)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.PopulatePrimaryFileData(String primaryFilePath)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile..ctor(SqlManagementUserControl parent, CDataContainer dc, String fullPath, String databaseOwner, ServerConnection connectionInfo)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.IsSelectedFileValid(BrowseFolder dlg)
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.PrimaryFile.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
===================================
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'E:\Navision SqlData\ForentaSQL_Data.mdf'. (.Net SqlClient Data Provider)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3159&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476
Server Name: twdlaptop1
Error Number: 5123
Severity: 16
State: 20
Line Number: 1
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)
It looks as though your problem is a permissions problem. When you're at home you're using a different login context than you are when you're at work. The external HD allows the work login access, but not the home login. I'd look at the security tab under the properties menu item for the directory where the database files are stored and see if you can add your home login to the list of allowed users.
Wednesday, March 7, 2012
Database "Suspect"
For whatever reason, I have a database marked as "Suspect". I didn't find
any clue from the error log. The drive has plenty of free spaces. I don't
have the backup files. Any suggestion to recover?
Thanks a lot,
LX
Hi
Tibor Karaszi has very good article about this issue.
http://www.karaszi.com/sqlserver/default.asp
"FLX" <nospam@.hotmail.com> wrote in message
news:Olmb3%23pjEHA.3876@.TK2MSFTNGP15.phx.gbl...
> For whatever reason, I have a database marked as "Suspect". I didn't find
> any clue from the error log. The drive has plenty of free spaces. I don't
> have the backup files. Any suggestion to recover?
> Thanks a lot,
> LX
>
>
>
>
any clue from the error log. The drive has plenty of free spaces. I don't
have the backup files. Any suggestion to recover?
Thanks a lot,
LX
Hi
Tibor Karaszi has very good article about this issue.
http://www.karaszi.com/sqlserver/default.asp
"FLX" <nospam@.hotmail.com> wrote in message
news:Olmb3%23pjEHA.3876@.TK2MSFTNGP15.phx.gbl...
> For whatever reason, I have a database marked as "Suspect". I didn't find
> any clue from the error log. The drive has plenty of free spaces. I don't
> have the backup files. Any suggestion to recover?
> Thanks a lot,
> LX
>
>
>
>
Database "Suspect"
For whatever reason, I have a database marked as "Suspect". I didn't find
any clue from the error log. The drive has plenty of free spaces. I don't
have the backup files. Any suggestion to recover?
Thanks a lot,
LXHi
Tibor Karaszi has very good article about this issue.
http://www.karaszi.com/sqlserver/default.asp
"FLX" <nospam@.hotmail.com> wrote in message
news:Olmb3%23pjEHA.3876@.TK2MSFTNGP15.phx.gbl...
> For whatever reason, I have a database marked as "Suspect". I didn't find
> any clue from the error log. The drive has plenty of free spaces. I don't
> have the backup files. Any suggestion to recover?
> Thanks a lot,
> LX
>
>
>
>|||Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked
as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of
free spaces. I don't
>have the backup files. Any suggestion to recover?
>Thanks a lot,
>LX
>
>
>
>
>.
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0023_01C48E73.F0CAC3E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Detaching a suspect database can lead to big problems, especially since =you cannot attach a corrupt database. If the database is suspect =because of recovery failures, and you try to attach it again, the attach =command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." <anonymous@.discussions.microsoft.com> wrote in message =news:08f701c48ea2$fbcb5730$a401280a@.phx.gbl...
Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of free spaces. I don't
>have the backup files. Any suggestion to recover?
>
>Thanks a lot,
>LX
>
>
>
>
>
>
>
>
>.
>
--=_NextPart_000_0023_01C48E73.F0CAC3E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Detaching a suspect database can lead to big =problems, especially since you cannot attach a corrupt database. If the =database is suspect because of recovery failures, and you try to attach it again, =the attach command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." wrote in message news:08f701c48ea2$fb=cb5730$a401280a@.phx.gbl...Try dettach + attaching the database...>--Original Message-->For whatever reason, I have a database marked =as "Suspect". I didn't find>any clue from the error log. The drive =has plenty of free spaces. I don't>have the backup files. =Any suggestion to recover?>>Thanks a =lot,>LX>>>>>>>>>.>
--=_NextPart_000_0023_01C48E73.F0CAC3E0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000A_01C48E96.A5005EC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Exactly! That is my problem now. Here is error message:
I/O error (torn page) detected during read at offset 0x0000002979e000 in =file "c:\XXXXXX"
What should I do to fix it?
Thanks in advance,
LX
"Ryan Stonecipher [MSFT]" <ryanston@.online.microsoft.com> wrote in =message news:eUfSe6qjEHA.704@.TK2MSFTNGP12.phx.gbl...
Detaching a suspect database can lead to big problems, especially =since you cannot attach a corrupt database. If the database is suspect =because of recovery failures, and you try to attach it again, the attach =command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." <anonymous@.discussions.microsoft.com> wrote in message =news:08f701c48ea2$fbcb5730$a401280a@.phx.gbl...
Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of free spaces. I don't
>have the backup files. Any suggestion to recover?
>
>Thanks a lot,
>LX
>
>
>
>
>
>
>
>
>.
>
--=_NextPart_000_000A_01C48E96.A5005EC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Exactly! That is my problem now. Here =is error message:
I/O error (torn page) detected during =read at offset 0x0000002979e000 in file "c:\XXXXXX"
What should I do to fix =it?
Thanks in advance,
LX
"Ryan Stonecipher [MSFT]" wrote in message news:eUfSe6qjEHA.704@.T=K2MSFTNGP12.phx.gbl...
Detaching a suspect database can lead to big =problems, especially since you cannot attach a corrupt database. If the =database is suspect because of recovery failures, and you try to attach it =again, the attach command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." wrote in message news:08f701c48ea2$fb=cb5730$a401280a@.phx.gbl...Try dettach + attaching the database...>--Original Message-->For whatever reason, I have a database marked =as "Suspect". I didn't find>any clue from the error log. The =drive has plenty of free spaces. I don't>have the backup =files. Any suggestion to recover?>>Thanks a =lot,>LX>>>>>>>>>.>
--=_NextPart_000_000A_01C48E96.A5005EC0--|||As I remember, the repair will remove the torn page, and all that depends on it. I.e., you never
know how much data you will lose. I strongly encourage you to either restore from a healthy backup,
or open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"FLX" <nospam@.hotmail.com> wrote in message news:%23rI67AsjEHA.556@.tk2msftngp13.phx.gbl...
Exactly! That is my problem now. Here is error message:
I/O error (torn page) detected during read at offset 0x0000002979e000 in file "c:\XXXXXX"
What should I do to fix it?
Thanks in advance,
LX
"Ryan Stonecipher [MSFT]" <ryanston@.online.microsoft.com> wrote in message
news:eUfSe6qjEHA.704@.TK2MSFTNGP12.phx.gbl...
Detaching a suspect database can lead to big problems, especially since you cannot attach a
corrupt database. If the database is suspect because of recovery failures, and you try to attach it
again, the attach command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." <anonymous@.discussions.microsoft.com> wrote in message
news:08f701c48ea2$fbcb5730$a401280a@.phx.gbl...
Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked
as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of
free spaces. I don't
>have the backup files. Any suggestion to recover?
>
>Thanks a lot,
>LX
>
>
>
>
>
>
>
>
>.
>
any clue from the error log. The drive has plenty of free spaces. I don't
have the backup files. Any suggestion to recover?
Thanks a lot,
LXHi
Tibor Karaszi has very good article about this issue.
http://www.karaszi.com/sqlserver/default.asp
"FLX" <nospam@.hotmail.com> wrote in message
news:Olmb3%23pjEHA.3876@.TK2MSFTNGP15.phx.gbl...
> For whatever reason, I have a database marked as "Suspect". I didn't find
> any clue from the error log. The drive has plenty of free spaces. I don't
> have the backup files. Any suggestion to recover?
> Thanks a lot,
> LX
>
>
>
>|||Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked
as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of
free spaces. I don't
>have the backup files. Any suggestion to recover?
>Thanks a lot,
>LX
>
>
>
>
>.
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0023_01C48E73.F0CAC3E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Detaching a suspect database can lead to big problems, especially since =you cannot attach a corrupt database. If the database is suspect =because of recovery failures, and you try to attach it again, the attach =command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." <anonymous@.discussions.microsoft.com> wrote in message =news:08f701c48ea2$fbcb5730$a401280a@.phx.gbl...
Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of free spaces. I don't
>have the backup files. Any suggestion to recover?
>
>Thanks a lot,
>LX
>
>
>
>
>
>
>
>
>.
>
--=_NextPart_000_0023_01C48E73.F0CAC3E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Detaching a suspect database can lead to big =problems, especially since you cannot attach a corrupt database. If the =database is suspect because of recovery failures, and you try to attach it again, =the attach command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." wrote in message news:08f701c48ea2$fb=cb5730$a401280a@.phx.gbl...Try dettach + attaching the database...>--Original Message-->For whatever reason, I have a database marked =as "Suspect". I didn't find>any clue from the error log. The drive =has plenty of free spaces. I don't>have the backup files. =Any suggestion to recover?>>Thanks a =lot,>LX>>>>>>>>>.>
--=_NextPart_000_0023_01C48E73.F0CAC3E0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000A_01C48E96.A5005EC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Exactly! That is my problem now. Here is error message:
I/O error (torn page) detected during read at offset 0x0000002979e000 in =file "c:\XXXXXX"
What should I do to fix it?
Thanks in advance,
LX
"Ryan Stonecipher [MSFT]" <ryanston@.online.microsoft.com> wrote in =message news:eUfSe6qjEHA.704@.TK2MSFTNGP12.phx.gbl...
Detaching a suspect database can lead to big problems, especially =since you cannot attach a corrupt database. If the database is suspect =because of recovery failures, and you try to attach it again, the attach =command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." <anonymous@.discussions.microsoft.com> wrote in message =news:08f701c48ea2$fbcb5730$a401280a@.phx.gbl...
Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of free spaces. I don't
>have the backup files. Any suggestion to recover?
>
>Thanks a lot,
>LX
>
>
>
>
>
>
>
>
>.
>
--=_NextPart_000_000A_01C48E96.A5005EC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Exactly! That is my problem now. Here =is error message:
I/O error (torn page) detected during =read at offset 0x0000002979e000 in file "c:\XXXXXX"
What should I do to fix =it?
Thanks in advance,
LX
"Ryan Stonecipher [MSFT]"
Detaching a suspect database can lead to big =problems, especially since you cannot attach a corrupt database. If the =database is suspect because of recovery failures, and you try to attach it =again, the attach command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." wrote in message news:08f701c48ea2$fb=cb5730$a401280a@.phx.gbl...Try dettach + attaching the database...>--Original Message-->For whatever reason, I have a database marked =as "Suspect". I didn't find>any clue from the error log. The =drive has plenty of free spaces. I don't>have the backup =files. Any suggestion to recover?>>Thanks a =lot,>LX>>>>>>>>>.>
--=_NextPart_000_000A_01C48E96.A5005EC0--|||As I remember, the repair will remove the torn page, and all that depends on it. I.e., you never
know how much data you will lose. I strongly encourage you to either restore from a healthy backup,
or open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"FLX" <nospam@.hotmail.com> wrote in message news:%23rI67AsjEHA.556@.tk2msftngp13.phx.gbl...
Exactly! That is my problem now. Here is error message:
I/O error (torn page) detected during read at offset 0x0000002979e000 in file "c:\XXXXXX"
What should I do to fix it?
Thanks in advance,
LX
"Ryan Stonecipher [MSFT]" <ryanston@.online.microsoft.com> wrote in message
news:eUfSe6qjEHA.704@.TK2MSFTNGP12.phx.gbl...
Detaching a suspect database can lead to big problems, especially since you cannot attach a
corrupt database. If the database is suspect because of recovery failures, and you try to attach it
again, the attach command will fail.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"..." <anonymous@.discussions.microsoft.com> wrote in message
news:08f701c48ea2$fbcb5730$a401280a@.phx.gbl...
Try dettach + attaching the database...
>--Original Message--
>For whatever reason, I have a database marked
as "Suspect". I didn't find
>any clue from the error log. The drive has plenty of
free spaces. I don't
>have the backup files. Any suggestion to recover?
>
>Thanks a lot,
>LX
>
>
>
>
>
>
>
>
>.
>
Database "Suspect"
For whatever reason, I have a database marked as "Suspect". I didn't find
any clue from the error log. The drive has plenty of free spaces. I don't
have the backup files. Any suggestion to recover?
Thanks a lot,
LXHi
Tibor Karaszi has very good article about this issue.
http://www.karaszi.com/sqlserver/default.asp
"FLX" <nospam@.hotmail.com> wrote in message
news:Olmb3%23pjEHA.3876@.TK2MSFTNGP15.phx.gbl...
> For whatever reason, I have a database marked as "Suspect". I didn't find
> any clue from the error log. The drive has plenty of free spaces. I don't
> have the backup files. Any suggestion to recover?
> Thanks a lot,
> LX
>
>
>
>
any clue from the error log. The drive has plenty of free spaces. I don't
have the backup files. Any suggestion to recover?
Thanks a lot,
LXHi
Tibor Karaszi has very good article about this issue.
http://www.karaszi.com/sqlserver/default.asp
"FLX" <nospam@.hotmail.com> wrote in message
news:Olmb3%23pjEHA.3876@.TK2MSFTNGP15.phx.gbl...
> For whatever reason, I have a database marked as "Suspect". I didn't find
> any clue from the error log. The drive has plenty of free spaces. I don't
> have the backup files. Any suggestion to recover?
> Thanks a lot,
> LX
>
>
>
>
Subscribe to:
Posts (Atom)