I am currently using Veritas Netbackup to backup the filesystem on my SQL
server.
Currently, a whole host of .mdf and .ldf files in the <\Program
Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the backup
software because they are in use by another process.
Is there any way to perform a flatfile backup of MSSQL database without
using any software agents? Or must the db be offlined each time in order to
free up those .mdf/.ldf files to be backed up?
Thanks!
"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
You need to use SQL Server's own native backups to backup the database while
its online. That's something you should definitely do anyway because you
have many more options to control just how the files get backed up and
restored. Read the backup topics in SQL Server Books Online.
Veritas has an agent module that allows you to manage native SQL Server
backups through their software.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Hi
You cannot copy files while a database is in use, however you will be able
to issue BACKUP DATABASE command
"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
Showing posts with label netbackup. Show all posts
Showing posts with label netbackup. Show all posts
Tuesday, March 20, 2012
Backup db files
I am currently using Veritas Netbackup to backup the filesystem on my SQL
server.
Currently, a whole host of .mdf and .ldf files in the <\Program
Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the backup
software because they are in use by another process.
Is there any way to perform a flatfile backup of MSSQL database without
using any software agents? Or must the db be offlined each time in order to
free up those .mdf/.ldf files to be backed up?
Thanks!"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
You need to use SQL Server's own native backups to backup the database while
its online. That's something you should definitely do anyway because you
have many more options to control just how the files get backed up and
restored. Read the backup topics in SQL Server Books Online.
Veritas has an agent module that allows you to manage native SQL Server
backups through their software.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi
You cannot copy files while a database is in use, however you will be able
to issue BACKUP DATABASE command
"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
server.
Currently, a whole host of .mdf and .ldf files in the <\Program
Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the backup
software because they are in use by another process.
Is there any way to perform a flatfile backup of MSSQL database without
using any software agents? Or must the db be offlined each time in order to
free up those .mdf/.ldf files to be backed up?
Thanks!"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
You need to use SQL Server's own native backups to backup the database while
its online. That's something you should definitely do anyway because you
have many more options to control just how the files get backed up and
restored. Read the backup topics in SQL Server Books Online.
Veritas has an agent module that allows you to manage native SQL Server
backups through their software.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi
You cannot copy files while a database is in use, however you will be able
to issue BACKUP DATABASE command
"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
Backup db files
I am currently using Veritas Netbackup to backup the filesystem on my SQL
server.
Currently, a whole host of .mdf and .ldf files in the <\Program
Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the backup
software because they are in use by another process.
Is there any way to perform a flatfile backup of MSSQL database without
using any software agents? Or must the db be offlined each time in order to
free up those .mdf/.ldf files to be backed up?
Thanks!"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
You need to use SQL Server's own native backups to backup the database while
its online. That's something you should definitely do anyway because you
have many more options to control just how the files get backed up and
restored. Read the backup topics in SQL Server Books Online.
Veritas has an agent module that allows you to manage native SQL Server
backups through their software.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi
You cannot copy files while a database is in use, however you will be able
to issue BACKUP DATABASE command
"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
server.
Currently, a whole host of .mdf and .ldf files in the <\Program
Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the backup
software because they are in use by another process.
Is there any way to perform a flatfile backup of MSSQL database without
using any software agents? Or must the db be offlined each time in order to
free up those .mdf/.ldf files to be backed up?
Thanks!"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
You need to use SQL Server's own native backups to backup the database while
its online. That's something you should definitely do anyway because you
have many more options to control just how the files get backed up and
restored. Read the backup topics in SQL Server Books Online.
Veritas has an agent module that allows you to manage native SQL Server
backups through their software.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi
You cannot copy files while a database is in use, however you will be able
to issue BACKUP DATABASE command
"Merc76" <Merc76@.discussions.microsoft.com> wrote in message
news:B01DF591-88C1-4C33-854C-8E151E180018@.microsoft.com...
>I am currently using Veritas Netbackup to backup the filesystem on my SQL
> server.
> Currently, a whole host of .mdf and .ldf files in the <\Program
> Files\Microsoft SQL Server\MSSQL\Data> directory are skipped by the
> backup
> software because they are in use by another process.
> Is there any way to perform a flatfile backup of MSSQL database without
> using any software agents? Or must the db be offlined each time in order
> to
> free up those .mdf/.ldf files to be backed up?
> Thanks!
Sunday, February 12, 2012
Backing up Windows Server with SQL server installed
I'm trying to find a way to shutdown the SQL server service on a Windows
Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
I'm currently backuping the SQL server throught the SQL server maintenance
plans and it works fine.
Now when I try to backup the entire server with netbackup the SQL database
files are not getting backed up because they are open. We currently do not
have a SQL client agent license for the netbackup so I want to shut down the
SQL server durning the netbackup process and turn it back on after.
I have tried to use net stop and start but SQL seems to restart on it's own
before the backup process is finished. Does anyone know of another method
to shut down the SQL server gracefully and start it back up again through a
batch file or script ? Any help would be great.
Thank you
Chris IThis is the wrong way to back up SQL Server database files. Either you run
a sp_detach_db statement first, then back up the files, or you use the
standard BACKUP T-SQL commands. Stopping the service and backing up the
files is wrong.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Chris I" <dmagic@.nycap.rr.com> wrote in message
news:%23$ekzEmpEHA.1952@.TK2MSFTNGP12.phx.gbl...
> I'm trying to find a way to shutdown the SQL server service on a Windows
> Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
> I'm currently backuping the SQL server throught the SQL server maintenance
> plans and it works fine.
> Now when I try to backup the entire server with netbackup the SQL database
> files are not getting backed up because they are open. We currently do
not
> have a SQL client agent license for the netbackup so I want to shut down
the
> SQL server durning the netbackup process and turn it back on after.
> I have tried to use net stop and start but SQL seems to restart on it's
own
> before the backup process is finished. Does anyone know of another method
> to shut down the SQL server gracefully and start it back up again through
a
> batch file or script ? Any help would be great.
> Thank you
> Chris I
>
Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
I'm currently backuping the SQL server throught the SQL server maintenance
plans and it works fine.
Now when I try to backup the entire server with netbackup the SQL database
files are not getting backed up because they are open. We currently do not
have a SQL client agent license for the netbackup so I want to shut down the
SQL server durning the netbackup process and turn it back on after.
I have tried to use net stop and start but SQL seems to restart on it's own
before the backup process is finished. Does anyone know of another method
to shut down the SQL server gracefully and start it back up again through a
batch file or script ? Any help would be great.
Thank you
Chris IThis is the wrong way to back up SQL Server database files. Either you run
a sp_detach_db statement first, then back up the files, or you use the
standard BACKUP T-SQL commands. Stopping the service and backing up the
files is wrong.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Chris I" <dmagic@.nycap.rr.com> wrote in message
news:%23$ekzEmpEHA.1952@.TK2MSFTNGP12.phx.gbl...
> I'm trying to find a way to shutdown the SQL server service on a Windows
> Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
> I'm currently backuping the SQL server throught the SQL server maintenance
> plans and it works fine.
> Now when I try to backup the entire server with netbackup the SQL database
> files are not getting backed up because they are open. We currently do
not
> have a SQL client agent license for the netbackup so I want to shut down
the
> SQL server durning the netbackup process and turn it back on after.
> I have tried to use net stop and start but SQL seems to restart on it's
own
> before the backup process is finished. Does anyone know of another method
> to shut down the SQL server gracefully and start it back up again through
a
> batch file or script ? Any help would be great.
> Thank you
> Chris I
>
Backing up Windows Server with SQL server installed
I'm trying to find a way to shutdown the SQL server service on a Windows
Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
I'm currently backuping the SQL server throught the SQL server maintenance
plans and it works fine.
Now when I try to backup the entire server with netbackup the SQL database
files are not getting backed up because they are open. We currently do not
have a SQL client agent license for the netbackup so I want to shut down the
SQL server durning the netbackup process and turn it back on after.
I have tried to use net stop and start but SQL seems to restart on it's own
before the backup process is finished. Does anyone know of another method
to shut down the SQL server gracefully and start it back up again through a
batch file or script ? Any help would be great.
Thank you
Chris I
This is the wrong way to back up SQL Server database files. Either you run
a sp_detach_db statement first, then back up the files, or you use the
standard BACKUP T-SQL commands. Stopping the service and backing up the
files is wrong.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Chris I" <dmagic@.nycap.rr.com> wrote in message
news:%23$ekzEmpEHA.1952@.TK2MSFTNGP12.phx.gbl...
> I'm trying to find a way to shutdown the SQL server service on a Windows
> Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
> I'm currently backuping the SQL server throught the SQL server maintenance
> plans and it works fine.
> Now when I try to backup the entire server with netbackup the SQL database
> files are not getting backed up because they are open. We currently do
not
> have a SQL client agent license for the netbackup so I want to shut down
the
> SQL server durning the netbackup process and turn it back on after.
> I have tried to use net stop and start but SQL seems to restart on it's
own
> before the backup process is finished. Does anyone know of another method
> to shut down the SQL server gracefully and start it back up again through
a
> batch file or script ? Any help would be great.
> Thank you
> Chris I
>
Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
I'm currently backuping the SQL server throught the SQL server maintenance
plans and it works fine.
Now when I try to backup the entire server with netbackup the SQL database
files are not getting backed up because they are open. We currently do not
have a SQL client agent license for the netbackup so I want to shut down the
SQL server durning the netbackup process and turn it back on after.
I have tried to use net stop and start but SQL seems to restart on it's own
before the backup process is finished. Does anyone know of another method
to shut down the SQL server gracefully and start it back up again through a
batch file or script ? Any help would be great.
Thank you
Chris I
This is the wrong way to back up SQL Server database files. Either you run
a sp_detach_db statement first, then back up the files, or you use the
standard BACKUP T-SQL commands. Stopping the service and backing up the
files is wrong.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Chris I" <dmagic@.nycap.rr.com> wrote in message
news:%23$ekzEmpEHA.1952@.TK2MSFTNGP12.phx.gbl...
> I'm trying to find a way to shutdown the SQL server service on a Windows
> Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
> I'm currently backuping the SQL server throught the SQL server maintenance
> plans and it works fine.
> Now when I try to backup the entire server with netbackup the SQL database
> files are not getting backed up because they are open. We currently do
not
> have a SQL client agent license for the netbackup so I want to shut down
the
> SQL server durning the netbackup process and turn it back on after.
> I have tried to use net stop and start but SQL seems to restart on it's
own
> before the backup process is finished. Does anyone know of another method
> to shut down the SQL server gracefully and start it back up again through
a
> batch file or script ? Any help would be great.
> Thank you
> Chris I
>
Subscribe to:
Posts (Atom)