Backup Errors in sqlserver

Hello all,

How can I resolve this error message I keep getting when I try to backup my database?

Thanks in Advance.

"Can't open dump device 'D:\MSSQL\BACKUP\dmpApp_tracker.DAT', device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)"Are you appending to the device? I've seen this happen when an active backup operation gets interrupted. After that the device needs to be re-created. If you were appending backups to it see if you can recover the ones that you intend to keep.|||No, I am not appending to it. This is sqlserver 6.5 and it does not give you that option. It does have a expire after date and I set that to 7. Thanks for the help.|||6.5?

Deal me out...

What did the error log say?|||Yes it does! WITH NOINIT is available in 6.5 SP5a, look closely!

Backup Device error or device off-line.

I received the error message listed below when the SQL
Server backup maintenance job runs daily. The server was
Windows 2000 Advanced Server with SQL Server 2000
Enterprise Edition and SP3. I can backup the database
manually with SQL Server in the same directory without a
problem.
Please help me resolve this issue.
Thanks,
Dan
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
backup device 'K:\MARKDEV_db_200406160300.BAK'. Device
error or device off-line. See the SQL Server error log for
more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY
DATABASE is terminating abnormally.
Hi,
Can you check the Windows Event viwer application log for more errors.
Hopefully you will get more explanation of this error there.
Is this K drive a local drive or remote drive? If it is remote drive then
start the SQLServerAgent service using
a domain account with write access to Kdrive
Thanks
Hari
MCDBA
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:1d3fc01c453a1$f0edc190$a401280a@.phx.gbl...
> I received the error message listed below when the SQL
> Server backup maintenance job runs daily. The server was
> Windows 2000 Advanced Server with SQL Server 2000
> Enterprise Edition and SP3. I can backup the database
> manually with SQL Server in the same directory without a
> problem.
> Please help me resolve this issue.
> Thanks,
> Dan
>
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
> backup device 'K:\MARKDEV_db_200406160300.BAK'. Device
> error or device off-line. See the SQL Server error log for
> more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY
> DATABASE is terminating abnormally.
>

Backup Device error or device off-line.

I received the error message listed below when the SQL
Server backup maintenance job runs daily. The server was
Windows 2000 Advanced Server with SQL Server 2000
Enterprise Edition and SP3. I can backup the database
manually with SQL Server in the same directory without a
problem.
Please help me resolve this issue.
Thanks,
Dan
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
backup device 'K:\MARKDEV_db_200406160300.BAK'. Device
error or device off-line. See the SQL Server error log for
more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY
DATABASE is terminating abnormally.Hi,
Can you check the Windows Event viwer application log for more errors.
Hopefully you will get more explanation of this error there.
Is this K drive a local drive or remote drive? If it is remote drive then
start the SQLServerAgent service using
a domain account with write access to Kdrive
Thanks
Hari
MCDBA
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:1d3fc01c453a1$f0edc190$a401280a@.phx
.gbl...
> I received the error message listed below when the SQL
> Server backup maintenance job runs daily. The server was
> Windows 2000 Advanced Server with SQL Server 2000
> Enterprise Edition and SP3. I can backup the database
> manually with SQL Server in the same directory without a
> problem.
> Please help me resolve this issue.
> Thanks,
> Dan
>
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
> backup device 'K:\MARKDEV_db_200406160300.BAK'. Device
> error or device off-line. See the SQL Server error log for
> more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY
> DATABASE is terminating abnormally.
>

backup db occurs error

Now I meet a question when backup SQLserver7.0,It prompt me the following attachment and I check the SQLserver log :"Using 'xpsql70.dll' version '1998.11.13' to execute extended stored procedure 'xp_msver'.
Error: 9002, Severity: 17, State: 2,The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.."

Pls help me. Thanks with best regards.Error: 9002, Severity: 17, State: 2,The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.."

I am receiving this error when attempting a restore of a 7.0 database. The log is set to autoextend. Immediately following these messages I am getting a "write failure on backup device".

Anyone experiencing these problems? Could it be that tempdb's log file has been corrupted? Any help with this would be greatly appreciated.

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!

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!

Backup DATABASE is terminating

I continue to get the following error when creating SQL Backup from SQL
server to Backup server:
The file on device '\\SERSQL1V\SQLBACK\DATA\' is not a valid Microsoft Format
backup set. [SQLSTATE 42000] (Error 3242) BACKUP
DATABASE is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed.
SQLBACK is shared folder on the SERSQL1V and from another sql server2 i have
no problem to save backup file but from this new server i have this error
message and
Espen
Check tha tboth services (MSSQLSERVER and SQLSERVERAGENT) are using a domain
account with rights to write and read from / to the shared folder.
AMB
"Espen" wrote:

> I continue to get the following error when creating SQL Backup from SQL
> server to Backup server:
> The file on device '\\SERSQL1V\SQLBACK\DATA\' is not a valid Microsoft Format
> backup set. [SQLSTATE 42000] (Error 3242) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000]
> (Error 3013). The step failed.
> SQLBACK is shared folder on the SERSQL1V and from another sql server2 i have
> no problem to save backup file but from this new server i have this error
> message and
> --
> Espen
|||Now error message is
Cannot open backup device'\\SERSQL1V\SQLBACK\DATA\Trans'. Device error or
device off-line. Backup database is terminating abnormally.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Check tha tboth services (MSSQLSERVER and SQLSERVERAGENT) are using a domain
> account with rights to write and read from / to the shared folder.
>
> AMB
> "Espen" wrote:
|||Are you doing a backup to a device or to a disk?
Can you post the statement used to do the backup?
AMB
"Espen" wrote:
[vbcol=seagreen]
> Now error message is
> Cannot open backup device'\\SERSQL1V\SQLBACK\DATA\Trans'. Device error or
> device off-line. Backup database is terminating abnormally.
> --
> Espen
>
> "Alejandro Mesa" wrote:
|||I am doing backup to a device. I am on the SERAX1V (This is SQL Server) and
making backup on the our Backup server name SQLSER1V (This is backup server).
I am using SQL Server Enterprise Manager for making backup.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Are you doing a backup to a device or to a disk?
> Can you post the statement used to do the backup?
>
> AMB
> "Espen" wrote:
|||Can you view the contents of the device from EM?
AMB
"Espen" wrote:
[vbcol=seagreen]
> I am doing backup to a device. I am on the SERAX1V (This is SQL Server) and
> making backup on the our Backup server name SQLSER1V (This is backup server).
> I am using SQL Server Enterprise Manager for making backup.
> --
> Espen
>
> "Alejandro Mesa" wrote:
|||I can able to view the contents of the device (Server: SQLSER1V) from EM of
SERAX1V. I am just able to see the content of local server C, D and E.
Error log file shows
BACKUP failed to complete the command BACKUP DATABASE [ABFT] TO DISK =
N'\\SERSQL1V\SQLBACK\DATA\Trans' WITH NOINIT , NOUNLOAD , NAME = N'AxpMBF
backup', NOSKIP , STATS = 10, NOFORMAT
will i need to login with Domain and Local server Administrator? I am login
only with Local Server Administrator.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Can you view the contents of the device from EM?
>
> AMB
> "Espen" wrote:
|||It is doing a backup to a file. From EM, right click over the server and
check what account is using the service in the security tab. Is it "system
account"?. The same if you right click over management - SQL Server Agent.
What account is being used under "service startup account", "system account"?
In both places, it should be a domain account, with enough rights to read
and write in the share folder.
See "Setting up Windows Services Accounts" in BOL for more info.
AMB
"Espen" wrote:
[vbcol=seagreen]
> I can able to view the contents of the device (Server: SQLSER1V) from EM of
> SERAX1V. I am just able to see the content of local server C, D and E.
> Error log file shows
> BACKUP failed to complete the command BACKUP DATABASE [ABFT] TO DISK =
> N'\\SERSQL1V\SQLBACK\DATA\Trans' WITH NOINIT , NOUNLOAD , NAME = N'AxpMBF
> backup', NOSKIP , STATS = 10, NOFORMAT
> will i need to login with Domain and Local server Administrator? I am login
> only with Local Server Administrator.
> --
> Espen
>
> "Alejandro Mesa" wrote:
|||Hei Alejandro
Thanks for your kind time it is going now very well!
Thanks a lot.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> It is doing a backup to a file. From EM, right click over the server and
> check what account is using the service in the security tab. Is it "system
> account"?. The same if you right click over management - SQL Server Agent.
> What account is being used under "service startup account", "system account"?
> In both places, it should be a domain account, with enough rights to read
> and write in the share folder.
> See "Setting up Windows Services Accounts" in BOL for more info.
>
> AMB
> "Espen" wrote:

Backup DATABASE is terminating

I continue to get the following error when creating SQL Backup from SQL
server to Backup server:
The file on device '\\SERSQL1V\SQLBACK\DATA' is not a valid Microsoft Form
at
backup set. [SQLSTATE 42000] (Error 3242) BACKUP
DATABASE is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed.
SQLBACK is shared folder on the SERSQL1V and from another sql server2 i have
no problem to save backup file but from this new server i have this error
message and
EspenCheck tha tboth services (MSSQLSERVER and SQLSERVERAGENT) are using a domain
account with rights to write and read from / to the shared folder.
AMB
"Espen" wrote:

> I continue to get the following error when creating SQL Backup from SQL
> server to Backup server:
> The file on device '\\SERSQL1V\SQLBACK\DATA' is not a valid Microsoft Fo
rmat
> backup set. [SQLSTATE 42000] (Error 3242) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000]
> (Error 3013). The step failed.
> SQLBACK is shared folder on the SERSQL1V and from another sql server2 i ha
ve
> no problem to save backup file but from this new server i have this error
> message and
> --
> Espen|||Now error message is
Cannot open backup device'\\SERSQL1V\SQLBACK\DATA\Trans'. Device error or
device off-line. Backup database is terminating abnormally.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Check tha tboth services (MSSQLSERVER and SQLSERVERAGENT) are using a doma
in
> account with rights to write and read from / to the shared folder.
>
> AMB
> "Espen" wrote:
>|||Are you doing a backup to a device or to a disk?
Can you post the statement used to do the backup?
AMB
"Espen" wrote:
[vbcol=seagreen]
> Now error message is
> Cannot open backup device'\\SERSQL1V\SQLBACK\DATA\Trans'. Device error or
> device off-line. Backup database is terminating abnormally.
> --
> Espen
>
> "Alejandro Mesa" wrote:
>|||I am doing backup to a device. I am on the SERAX1V (This is SQL Server) and
making backup on the our Backup server name SQLSER1V (This is backup server)
.
I am using SQL Server Enterprise Manager for making backup.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Are you doing a backup to a device or to a disk?
> Can you post the statement used to do the backup?
>
> AMB
> "Espen" wrote:
>|||Can you view the contents of the device from EM?
AMB
"Espen" wrote:
[vbcol=seagreen]
> I am doing backup to a device. I am on the SERAX1V (This is SQL Server) an
d
> making backup on the our Backup server name SQLSER1V (This is backup serve
r).
> I am using SQL Server Enterprise Manager for making backup.
> --
> Espen
>
> "Alejandro Mesa" wrote:
>|||I can able to view the contents of the device (Server: SQLSER1V) from EM of
SERAX1V. I am just able to see the content of local server C, D and E.
Error log file shows
BACKUP failed to complete the command BACKUP DATABASE [ABFT] TO DISK =
N'\\SERSQL1V\SQLBACK\DATA\Trans' WITH NOINIT , NOUNLOAD , NAME = N'AxpMBF
backup', NOSKIP , STATS = 10, NOFORMAT
will i need to login with Domain and Local server Administrator? I am login
only with Local Server Administrator.
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Can you view the contents of the device from EM?
>
> AMB
> "Espen" wrote:
>|||It is doing a backup to a file. From EM, right click over the server and
check what account is using the service in the security tab. Is it "system
account"?. The same if you right click over management - SQL Server Agent.
What account is being used under "service startup account", "system account"
?
In both places, it should be a domain account, with enough rights to read
and write in the share folder.
See "Setting up Windows Services Accounts" in BOL for more info.
AMB
"Espen" wrote:
[vbcol=seagreen]
> I can able to view the contents of the device (Server: SQLSER1V) from EM o
f
> SERAX1V. I am just able to see the content of local server C, D and E.
> Error log file shows
> BACKUP failed to complete the command BACKUP DATABASE [ABFT] TO DISK
=
> N'\\SERSQL1V\SQLBACK\DATA\Trans' WITH NOINIT , NOUNLOAD , NAME = N'AxpM
BF
> backup', NOSKIP , STATS = 10, NOFORMAT
> will i need to login with Domain and Local server Administrator? I am logi
n
> only with Local Server Administrator.
> --
> Espen
>
> "Alejandro Mesa" wrote:
>|||Hei Alejandro
Thanks for your kind time it is going now very well!
Thanks a lot.
--
Espen
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> It is doing a backup to a file. From EM, right click over the server and
> check what account is using the service in the security tab. Is it "system
> account"?. The same if you right click over management - SQL Server Agent.
> What account is being used under "service startup account", "system accoun
t"?
> In both places, it should be a domain account, with enough rights to read
> and write in the share folder.
> See "Setting up Windows Services Accounts" in BOL for more info.
>
> AMB
> "Espen" wrote:
>

backup database (sql server backup) and files (nt backup)

Hi!
pls. advise, I need to backup some files on hard drive
using NT backup utility and SQL Server database (using sql
server db backups) to one tape. If I backup first some
folders and files with nt backup utility and then sql
server database, the sql server database cannot be
restored ("not a valid sql server backup"). In the other
case (first backed up sql server db then files using nt
backup) I am getting message "inconsistent media, do not
append to this tape"
How can I solve this?
You must use the SQL Server BACKUP command to create a backup file on disk
(or directly to tape) first. Then you can copy this file to tape. You can
not backup the sql files directly with a native NT backup.
Andrew J. Kelly SQL MVP
"Gabriel" <anonymous@.discussions.microsoft.com> wrote in message
news:12d3001c418b3$612a9610$a001280a@.phx.gbl...
> Hi!
> pls. advise, I need to backup some files on hard drive
> using NT backup utility and SQL Server database (using sql
> server db backups) to one tape. If I backup first some
> folders and files with nt backup utility and then sql
> server database, the sql server database cannot be
> restored ("not a valid sql server backup"). In the other
> case (first backed up sql server db then files using nt
> backup) I am getting message "inconsistent media, do not
> append to this tape"
> How can I solve this?

backup database (sql server backup) and files (nt backup)

Hi!
pls. advise, I need to backup some files on hard drive
using NT backup utility and SQL Server database (using sql
server db backups) to one tape. If I backup first some
folders and files with nt backup utility and then sql
server database, the sql server database cannot be
restored ("not a valid sql server backup"). In the other
case (first backed up sql server db then files using nt
backup) I am getting message "inconsistent media, do not
append to this tape"
How can I solve this?You must use the SQL Server BACKUP command to create a backup file on disk
(or directly to tape) first. Then you can copy this file to tape. You can
not backup the sql files directly with a native NT backup.
Andrew J. Kelly SQL MVP
"Gabriel" <anonymous@.discussions.microsoft.com> wrote in message
news:12d3001c418b3$612a9610$a001280a@.phx
.gbl...
> Hi!
> pls. advise, I need to backup some files on hard drive
> using NT backup utility and SQL Server database (using sql
> server db backups) to one tape. If I backup first some
> folders and files with nt backup utility and then sql
> server database, the sql server database cannot be
> restored ("not a valid sql server backup"). In the other
> case (first backed up sql server db then files using nt
> backup) I am getting message "inconsistent media, do not
> append to this tape"
> How can I solve this?

Backup an entire database ...

Can someone give me the command to properly backup an entire database
including all security and what-not so I can move it to a different SQL
server? The restore command too would help!
Thanks!
JonJon,
An easier and faster way might be to detach the database copy the files over
to the new server and then reattch the database there. The commands to use
are sp_detach_db and sp_attach_db. Examples and syntax are provided in the
SQL Server Books Online.
HTH
Jerry
PS - Note that the logins for the database user accounts will not come over
using either method because the logins are stored in the Master system
database.
The following article will provide more information.
http://support.microsoft.com/?id=314546
"Jon Glazer" <jglazer.delete.me@.adconn.com> wrote in message
news:biEWe.23145$uD6.12122@.tornado.ohiordc.rr.com...
> Can someone give me the command to properly backup an entire database
> including all security and what-not so I can move it to a different SQL
> server? The restore command too would help!
> Thanks!
> Jon
>|||Wow thanks for the fast reply Jerry.
I just posted a second question regarding mirroring. Since the databases
are so huge I was wondering if that would be an alternative and how would I
go about doing that.
Jon
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uH0Ou5uuFHA.2960@.tk2msftngp13.phx.gbl...
> Jon,
> An easier and faster way might be to detach the database copy the files
> over to the new server and then reattch the database there. The commands
> to use are sp_detach_db and sp_attach_db. Examples and syntax are
> provided in the SQL Server Books Online.
> HTH
> Jerry
> PS - Note that the logins for the database user accounts will not come
> over using either method because the logins are stored in the Master
> system database.
> The following article will provide more information.
> http://support.microsoft.com/?id=314546
> "Jon Glazer" <jglazer.delete.me@.adconn.com> wrote in message
> news:biEWe.23145$uD6.12122@.tornado.ohiordc.rr.com...
>|||Some helpful links, I hope...
http://tinyurl.com/azar5
http://tinyurl.com/a6flz
"Jon Glazer" <jglazer.delete.me@.adconn.com> wrote in message
news:biEWe.23145$uD6.12122@.tornado.ohiordc.rr.com...
> Can someone give me the command to properly backup an entire database
> including all security and what-not so I can move it to a different SQL
> server? The restore command too would help!
> Thanks!
> Jon
>|||The following articles explain how to transfer logins after detach/attach:
http://support.microsoft.com/defaul...kb;en-us;314546
http://support.microsoft.com/defaul...kb;en-us;224071
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uH0Ou5uuFHA.2960@.tk2msftngp13.phx.gbl...
> Jon,
> An easier and faster way might be to detach the database copy the files
> over to the new server and then reattch the database there. The commands
> to use are sp_detach_db and sp_attach_db. Examples and syntax are
> provided in the SQL Server Books Online.
> HTH
> Jerry
> PS - Note that the logins for the database user accounts will not come
> over using either method because the logins are stored in the Master
> system database.
> The following article will provide more information.
> http://support.microsoft.com/?id=314546
> "Jon Glazer" <jglazer.delete.me@.adconn.com> wrote in message
> news:biEWe.23145$uD6.12122@.tornado.ohiordc.rr.com...
>