Backup Software

We are using SAN for the SQL Server 2000.
Someone mentions that since SQL Server is using cache during operation, when
we do the sanpshot of the SAN, the cache value has to be written to SAN. Is
it correct, what is the exact steps for this mechanism ?
Thanks"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:u0bsYJ5iGHA.4884@.TK2MSFTNGP03.phx.gbl...
> We are using SAN for the SQL Server 2000.
> Someone mentions that since SQL Server is using cache during operation,
> when we do the sanpshot of the SAN, the cache value has to be written to
> SAN. Is it correct,
Yes, that is correct. In effect the backup software requests that the
databse flush it's dirty pages to disk and prepare for the snapshot, then to
suspend writes while the snapshot is taken.

>what is the exact steps for this mechanism ?
VSS the Windows Volume Shadow Copy Service.
How Volume Shadow Copy Service Works
http://technet2.microsoft.com/Windo...3.mspx?mfr=true
That's how it should work. If your SAN software doesn't use VSS then you
should not use it to snapshot SQL Server databases.
David|||Dear David,
Thank you for your prompt reply.
Can you elaborate more about dirty pages ? Why they have to be flushed to
the disk ?
Rob
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ekh0FS5iGHA.4884@.TK2MSFTNGP03.phx.gbl...
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:u0bsYJ5iGHA.4884@.TK2MSFTNGP03.phx.gbl...
> Yes, that is correct. In effect the backup software requests that the
> databse flush it's dirty pages to disk and prepare for the snapshot, then
> to suspend writes while the snapshot is taken.
>
> VSS the Windows Volume Shadow Copy Service.
> How Volume Shadow Copy Service Works
> http://technet2.microsoft.com/Windo...3.mspx?mfr=true
>
> That's how it should work. If your SAN software doesn't use VSS then you
> should not use it to snapshot SQL Server databases.
> David
>|||"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:ei3PhW5iGHA.4512@.TK2MSFTNGP02.phx.gbl...
> Dear David,
> Thank you for your prompt reply.
> Can you elaborate more about dirty pages ? Why they have to be flushed to
> the disk ?
>
Dirty pages contain changes that a user has made to the database, but which
haven't been written to the data files yet. These changes have been
commited in the transaction logs, and they are real, complete, durable
transactions. If you don't flush these pages to disk before taking a
snapshot then you would loose data when restoring the database.
David

Backup Software

We are using SAN for the SQL Server 2000.
Someone mentions that since SQL Server is using cache during operation, when
we do the sanpshot of the SAN, the cache value has to be written to SAN. Is
it correct, what is the exact steps for this mechanism ?
Thanks"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:u0bsYJ5iGHA.4884@.TK2MSFTNGP03.phx.gbl...
> We are using SAN for the SQL Server 2000.
> Someone mentions that since SQL Server is using cache during operation,
> when we do the sanpshot of the SAN, the cache value has to be written to
> SAN. Is it correct,
Yes, that is correct. In effect the backup software requests that the
databse flush it's dirty pages to disk and prepare for the snapshot, then to
suspend writes while the snapshot is taken.
>what is the exact steps for this mechanism ?
VSS the Windows Volume Shadow Copy Service.
How Volume Shadow Copy Service Works
http://technet2.microsoft.com/WindowsServer/en/Library/2b0d2457-b7d8-42c3-b6c9-59c145b7765f1033.mspx?mfr=true
That's how it should work. If your SAN software doesn't use VSS then you
should not use it to snapshot SQL Server databases.
David|||Dear David,
Thank you for your prompt reply.
Can you elaborate more about dirty pages ? Why they have to be flushed to
the disk ?
Rob
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ekh0FS5iGHA.4884@.TK2MSFTNGP03.phx.gbl...
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:u0bsYJ5iGHA.4884@.TK2MSFTNGP03.phx.gbl...
>> We are using SAN for the SQL Server 2000.
>> Someone mentions that since SQL Server is using cache during operation,
>> when we do the sanpshot of the SAN, the cache value has to be written to
>> SAN. Is it correct,
> Yes, that is correct. In effect the backup software requests that the
> databse flush it's dirty pages to disk and prepare for the snapshot, then
> to suspend writes while the snapshot is taken.
>>what is the exact steps for this mechanism ?
> VSS the Windows Volume Shadow Copy Service.
> How Volume Shadow Copy Service Works
> http://technet2.microsoft.com/WindowsServer/en/Library/2b0d2457-b7d8-42c3-b6c9-59c145b7765f1033.mspx?mfr=true
>
> That's how it should work. If your SAN software doesn't use VSS then you
> should not use it to snapshot SQL Server databases.
> David
>|||"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:ei3PhW5iGHA.4512@.TK2MSFTNGP02.phx.gbl...
> Dear David,
> Thank you for your prompt reply.
> Can you elaborate more about dirty pages ? Why they have to be flushed to
> the disk ?
>
Dirty pages contain changes that a user has made to the database, but which
haven't been written to the data files yet. These changes have been
commited in the transaction logs, and they are real, complete, durable
transactions. If you don't flush these pages to disk before taking a
snapshot then you would loose data when restoring the database.
David

Backup publisher DB

Can I make a backup of my Publisher DB and then restore it on the
Subscriber, or this operation can generate problems?
Marco,
if you are using sql server 2005 you can use the option to "initialize with
backup". If not then you can do a nosync initialization. Once done, you'll
need to remove identity attributes for a nosync initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Yes, but on SQL 2000 you need to make the identity columns, triggers and
constraints Not For Replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco" <peska78@.tin.it> wrote in message
news:1172491146.648730.117190@.k78g2000cwa.googlegr oups.com...
> Can I make a backup of my Publisher DB and then restore it on the
> Subscriber, or this operation can generate problems?
>
|||Tanks for your answers.
I'm using SQL 2000; I have not understood very well the correct
procedure.
I have only few tables, every table has a unique identifier, no
dependencies, no idexes, no triggers.
If simply I export all data in tables, for example in .txt files, and
then I reimport the data in the other DB?

Backup operation/job fail information

Hi,
I would like to know about the internal information regarding sql backup
operation.
I want to monitor the Backup operation in all version of sql server. I am
able to get all the information from the msdb database but i'll not find any
information regarding backup fails.
Suppose i want to monitor a database in a certain time interval and i want
to collect data for successful backup and failed backup.
How do i collect these information through my code?
Should i read and parse Error log file or sql provide some system table or
stored procedure for this?
Or there are any api provided by sql?
I'm waiting for positive response.
Thanks n Regards,
Nikhil Kumar JainHi
Yes , Error Log should give you an info.
"Nikhil Kumar Jain" <NikhilKumarJain@.discussions.microsoft.com> wrote in
message news:B0074C50-F6B0-4370-B95A-8A8C7E7DB0AD@.microsoft.com...
> Hi,
> I would like to know about the internal information regarding sql backup
> operation.
> I want to monitor the Backup operation in all version of sql server. I am
> able to get all the information from the msdb database but i'll not find
> any
> information regarding backup fails.
> Suppose i want to monitor a database in a certain time interval and i want
> to collect data for successful backup and failed backup.
> How do i collect these information through my code?
> Should i read and parse Error log file or sql provide some system table or
> stored procedure for this?
> Or there are any api provided by sql?
> I'm waiting for positive response.
> Thanks n Regards,
> Nikhil Kumar Jain

Backup operation terminating abnormally

Hi.
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
Gerardo
Look up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo

Backup operation terminating abnormally

Hi.
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
GerardoLook up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo

Backup operation terminating abnormally

Hi.
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
GerardoLook up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo

Backup in multiple backup files

Hi folks
What are the advantages of specifying more than one backup file in the
backup operation.
One advantage I know is, it can be spread across multiple hard drives if
it is a huge database. Are there any other advantages for doing so.
Thanks in advance.
*** Sent via Developersdex http://www.examnotes.net ***Striping the backup allows SQL to do the backup more quickly... If you place
3 file names in the list, then SQL will divide the db into approximately 3
equal pieces and back each piece up in parallel... More importantly this
allows the restore to occur more quickly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Venkatesan" <nospam_venkat_asp@.yahoo.co.uk> wrote in message
news:Og5bAWPOFHA.1500@.TK2MSFTNGP09.phx.gbl...
> Hi folks
> What are the advantages of specifying more than one backup file in the
> backup operation.
> One advantage I know is, it can be spread across multiple hard drives if
> it is a huge database. Are there any other advantages for doing so.
> Thanks in advance.
> --
> *** Sent via Developersdex http://www.examnotes.net ***