Backup settings for server registrations in SQL Server Enterprise

Dear SQL-Server-Gurus
I have version 8.0 of the SQL Server Enterprise Manager with many server
registrations organized in groups. I would like to backup these settings to
use them on an other computer or to have a copy in case I have to reinstall
my computer.
Is there any way to create a backup of the setings in SQL Server Enterprise
Manager 8.0? Up until now I have not found an INI-File or matching registry
settings by myself. Any input is highly appreciated.
Kind regards
Gabriel
From what I know the information is stored in registry. You can backup(and
later restore) the following registry key:
"HKEY_CURRENT_USER\Software\Microsoft\Microsof t SQL Server\80
Tools\SQLEW\Registered Servers X".

quote:

---

Warning: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Use
Registry Editor at your own risk.

---

Anyway if you use Enterprise Manager on multiple clients you may take a look
at this page:
"Storing SQL Server 7.0 Server Registrations on a Centralized System"
http://www.windowsitpro.com/SQLServe...9750/9750.html
Cristian Lefter, SQL Server MVP
"Gabriel Martin" <GabrielMartin@.discussions.microsoft.com> wrote in message
news:6D500EC5-3352-4CA7-BD99-22DCA99506B6@.microsoft.com...
> Dear SQL-Server-Gurus
> I have version 8.0 of the SQL Server Enterprise Manager with many server
> registrations organized in groups. I would like to backup these settings
> to
> use them on an other computer or to have a copy in case I have to
> reinstall
> my computer.
> Is there any way to create a backup of the setings in SQL Server
> Enterprise
> Manager 8.0? Up until now I have not found an INI-File or matching
> registry
> settings by myself. Any input is highly appreciated.
> Kind regards
> Gabriel
>

backup question

Dear all,
i want to verify whether the following backup planning can restore to the
original environment or not
1.) backup master, msdb, model with full backup to bak
2.) backup all user database with full backup and tran log backup to bak
question
how about the DTS package, user login, replication, job schelding, is it can
restore when i backup to the master and model?Users, packages and jobs are all in the databases you are
backup up (DTS Packages - as long as they are saved to SQL
Server as the location) so backing up all of your databases
and restoring all databases, including system databases will
get things back.
Replication restore strategies depend on how you have
implemented replication. You'd want to backup the publisher,
distributor, subscriber. There are different strategies for
merge, transactional, snapshot replication. You can find
them in books online. Look up the index topic:
replication, backup and restore operations
-Sue
On Mon, 3 Oct 2005 04:17:13 -0700, Joe
<Joe@.discussions.microsoft.com> wrote:

>Dear all,
>i want to verify whether the following backup planning can restore to the
>original environment or not
>1.) backup master, msdb, model with full backup to bak
>2.) backup all user database with full backup and tran log backup to bak
>question
>how about the DTS package, user login, replication, job schelding, is it ca
n
>restore when i backup to the master and model?

Backup permission

Dear All,
Sorry this is probably a bit of an old chestnut, but I couldn't see it in
recent posts...
I understand that when you backup a db using SQL database backup, you need
to reapply the permissions when it is restored. (I notice that I have lost
the permissions on the backup).
2 questions:
- Is there a way to backup and keep the permissions?, if not
- Is there a way to backup the permissions separately and then reapply to
database once restored?
As a coda, I simply want to backup my db prior to making some changes and
want to know that it will restore OK if anything goes wrong (without
hassling the sysadmins). Am I going about it the best way?
Any comments much appreciated
Ivor
Ivor
Do you perform RESTORE to another server or to the same ?
If you restore the database and the database does not exist you need to have
CREATE DATABASE permissons.
If the database does exist you need to be a member of db_owner fixed
database role ( if I remember well)
If you do RESTORE to a new server , search on internet for
'sp_help_revlogin' stored procedure that provided by MS to move LOGINS
between computers running SQL Server.
"Ivor" <ivor.tillierREMOVETHIS@.westminster-pct.nhs.uk> wrote in message
news:%23f8PCGZzFHA.416@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Sorry this is probably a bit of an old chestnut, but I couldn't see it in
> recent posts...
> I understand that when you backup a db using SQL database backup, you need
> to reapply the permissions when it is restored. (I notice that I have
> lost the permissions on the backup).
> 2 questions:
> - Is there a way to backup and keep the permissions?, if not
> - Is there a way to backup the permissions separately and then reapply to
> database once restored?
> As a coda, I simply want to backup my db prior to making some changes and
> want to know that it will restore OK if anything goes wrong (without
> hassling the sysadmins). Am I going about it the best way?
> Any comments much appreciated
> Ivor
>
|||When you backup a database the permission in that database are backed up
with it. However, when you restore a backup on a different server, the
mapping between the users in the database and the logins on the server will
have been lost. The mapping goes via a generated ID for the login, and this
will be different on each server (and instance).
You can fix the mapping with the stored procedure sp_change_users_login, see
the KB article http://support.microsoft.com/kb/274188/ for the steps needed
to do this.
Jacco Schalkwijk
SQL Server MVP
"Ivor" <ivor.tillierREMOVETHIS@.westminster-pct.nhs.uk> wrote in message
news:%23f8PCGZzFHA.416@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Sorry this is probably a bit of an old chestnut, but I couldn't see it in
> recent posts...
> I understand that when you backup a db using SQL database backup, you need
> to reapply the permissions when it is restored. (I notice that I have
> lost the permissions on the backup).
> 2 questions:
> - Is there a way to backup and keep the permissions?, if not
> - Is there a way to backup the permissions separately and then reapply to
> database once restored?
> As a coda, I simply want to backup my db prior to making some changes and
> want to know that it will restore OK if anything goes wrong (without
> hassling the sysadmins). Am I going about it the best way?
> Any comments much appreciated
> Ivor
>

Backup permission

Dear All,
Sorry this is probably a bit of an old chestnut, but I couldn't see it in
recent posts...
I understand that when you backup a db using SQL database backup, you need
to reapply the permissions when it is restored. (I notice that I have lost
the permissions on the backup).
2 questions:
- Is there a way to backup and keep the permissions?, if not
- Is there a way to backup the permissions separately and then reapply to
database once restored?
As a coda, I simply want to backup my db prior to making some changes and
want to know that it will restore OK if anything goes wrong (without
hassling the sysadmins). Am I going about it the best way?
Any comments much appreciated
IvorIvor
Do you perform RESTORE to another server or to the same ?
If you restore the database and the database does not exist you need to have
CREATE DATABASE permissons.
If the database does exist you need to be a member of db_owner fixed
database role ( if I remember well)
If you do RESTORE to a new server , search on internet for
'sp_help_revlogin' stored procedure that provided by MS to move LOGINS
between computers running SQL Server.
"Ivor" <ivor.tillierREMOVETHIS@.westminster-pct.nhs.uk> wrote in message
news:%23f8PCGZzFHA.416@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Sorry this is probably a bit of an old chestnut, but I couldn't see it in
> recent posts...
> I understand that when you backup a db using SQL database backup, you need
> to reapply the permissions when it is restored. (I notice that I have
> lost the permissions on the backup).
> 2 questions:
> - Is there a way to backup and keep the permissions?, if not
> - Is there a way to backup the permissions separately and then reapply to
> database once restored?
> As a coda, I simply want to backup my db prior to making some changes and
> want to know that it will restore OK if anything goes wrong (without
> hassling the sysadmins). Am I going about it the best way?
> Any comments much appreciated
> Ivor
>|||When you backup a database the permission in that database are backed up
with it. However, when you restore a backup on a different server, the
mapping between the users in the database and the logins on the server will
have been lost. The mapping goes via a generated ID for the login, and this
will be different on each server (and instance).
You can fix the mapping with the stored procedure sp_change_users_login, see
the KB article http://support.microsoft.com/kb/274188/ for the steps needed
to do this.
--
Jacco Schalkwijk
SQL Server MVP
"Ivor" <ivor.tillierREMOVETHIS@.westminster-pct.nhs.uk> wrote in message
news:%23f8PCGZzFHA.416@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Sorry this is probably a bit of an old chestnut, but I couldn't see it in
> recent posts...
> I understand that when you backup a db using SQL database backup, you need
> to reapply the permissions when it is restored. (I notice that I have
> lost the permissions on the backup).
> 2 questions:
> - Is there a way to backup and keep the permissions?, if not
> - Is there a way to backup the permissions separately and then reapply to
> database once restored?
> As a coda, I simply want to backup my db prior to making some changes and
> want to know that it will restore OK if anything goes wrong (without
> hassling the sysadmins). Am I going about it the best way?
> Any comments much appreciated
> Ivor
>

Backup permission

Dear All,
Sorry this is probably a bit of an old chestnut, but I couldn't see it in
recent posts...
I understand that when you backup a db using SQL database backup, you need
to reapply the permissions when it is restored. (I notice that I have lost
the permissions on the backup).
2 questions:
- Is there a way to backup and keep the permissions?, if not
- Is there a way to backup the permissions separately and then reapply to
database once restored?
As a coda, I simply want to backup my db prior to making some changes and
want to know that it will restore OK if anything goes wrong (without
hassling the sysadmins). Am I going about it the best way?
Any comments much appreciated
IvorIvor
Do you perform RESTORE to another server or to the same ?
If you restore the database and the database does not exist you need to have
CREATE DATABASE permissons.
If the database does exist you need to be a member of db_owner fixed
database role ( if I remember well)
If you do RESTORE to a new server , search on internet for
'sp_help_revlogin' stored procedure that provided by MS to move LOGINS
between computers running SQL Server.
"Ivor" <ivor.tillierREMOVETHIS@.westminster-pct.nhs.uk> wrote in message
news:%23f8PCGZzFHA.416@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Sorry this is probably a bit of an old chestnut, but I couldn't see it in
> recent posts...
> I understand that when you backup a db using SQL database backup, you need
> to reapply the permissions when it is restored. (I notice that I have
> lost the permissions on the backup).
> 2 questions:
> - Is there a way to backup and keep the permissions?, if not
> - Is there a way to backup the permissions separately and then reapply to
> database once restored?
> As a coda, I simply want to backup my db prior to making some changes and
> want to know that it will restore OK if anything goes wrong (without
> hassling the sysadmins). Am I going about it the best way?
> Any comments much appreciated
> Ivor
>|||When you backup a database the permission in that database are backed up
with it. However, when you restore a backup on a different server, the
mapping between the users in the database and the logins on the server will
have been lost. The mapping goes via a generated ID for the login, and this
will be different on each server (and instance).
You can fix the mapping with the stored procedure sp_change_users_login, see
the KB article http://support.microsoft.com/kb/274188/ for the steps needed
to do this.
Jacco Schalkwijk
SQL Server MVP
"Ivor" <ivor.tillierREMOVETHIS@.westminster-pct.nhs.uk> wrote in message
news:%23f8PCGZzFHA.416@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Sorry this is probably a bit of an old chestnut, but I couldn't see it in
> recent posts...
> I understand that when you backup a db using SQL database backup, you need
> to reapply the permissions when it is restored. (I notice that I have
> lost the permissions on the backup).
> 2 questions:
> - Is there a way to backup and keep the permissions?, if not
> - Is there a way to backup the permissions separately and then reapply to
> database once restored?
> As a coda, I simply want to backup my db prior to making some changes and
> want to know that it will restore OK if anything goes wrong (without
> hassling the sysadmins). Am I going about it the best way?
> Any comments much appreciated
> Ivor
>

Backup on Network/Mapped drives Using Enterprise Manager

Dear all,
This is My Query step by step description:
1. I want to take backup of sql server databases on network drives(mapped
drives) Using Enterprise Manager tool only.
2. I am getting network drives list on some machines not on all machines
when I opened Backup Device location window in Enterprise Manager.
3. My SQL Server Services are also configured with domain administrator
account only.
Please let me know the way to get list of network drives when I am taking
backup using Enterprise Manager.(I know the way to work with SQL Query
Analyzer).
Thanks in Advance
Regards
Ravisrikrishna
You can't.
We've already explained this in your earlier post.
SQL EM only looks at physical drives.
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>
|||Hi
You need to specify UNC names and not use mapped drives.
John
"Lokesh Bhatnagar" wrote:

> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>
|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default...b;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>

Backup on Network/Mapped drives Using Enterprise Manager

Dear all,
This is My Query step by step description:
1. I want to take backup of sql server databases on network drives(mapped
drives) Using Enterprise Manager tool only.
2. I am getting network drives list on some machines not on all machines
when I opened Backup Device location window in Enterprise Manager.
3. My SQL Server Services are also configured with domain administrator
account only.
Please let me know the way to get list of network drives when I am taking
backup using Enterprise Manager.(I know the way to work with SQL Query
Analyzer).
Thanks in Advance
Regards
RavisrikrishnaYou can't.
We've already explained this in your earlier post.
SQL EM only looks at physical drives.
--
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||Hi
You need to specify UNC names and not use mapped drives.
John
"Lokesh Bhatnagar" wrote:
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>

Backup on Network/Mapped drives Using Enterprise Manager

Dear all,
This is My Query step by step description:
1. I want to take backup of sql server databases on network drives(mapped
drives) Using Enterprise Manager tool only.
2. I am getting network drives list on some machines not on all machines
when I opened Backup Device location window in Enterprise Manager.
3. My SQL Server Services are also configured with domain administrator
account only.
Please let me know the way to get list of network drives when I am taking
backup using Enterprise Manager.(I know the way to work with SQL Query
Analyzer).
Thanks in Advance
Regards
RavisrikrishnaYou can't.
We've already explained this in your earlier post.
SQL EM only looks at physical drives.
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||Hi
You need to specify UNC names and not use mapped drives.
John
"Lokesh Bhatnagar" wrote:

> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/defaul...kb;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>

Backup of Log files

Dear All,
My nightly backups for log files are failing as there are
users still attached to the database being backup up.
What is the best stratergy for dealing with this ?
Do I
1) Make the DB single user ?
2) Have a script to kill all connections
3) Modify my backup plans
4) Some other
Any help here would be greatly appriciated.
PeterHi Peter,
Which version of SQL Server do you use? SQL Server 2000 and 7 (and probably
some earlier versions as well, but I don't have experience with them) allow
database and log backups when there are users connected to the database.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Peter" <nospam@.thisemailaddress.co.uk> wrote in message
news:05ae01c35fe8$90bfb4c0$a101280a@.phx.gbl...
> Dear All,
> My nightly backups for log files are failing as there are
> users still attached to the database being backup up.
> What is the best stratergy for dealing with this ?
> Do I
> 1) Make the DB single user ?
> 2) Have a script to kill all connections
> 3) Modify my backup plans
> 4) Some other
> Any help here would be greatly appriciated.
> Peter|||Hello,
Thanks for both of your replies.
I am using SQL 2000. However the backups I am doing are
part of the database maintence plan backups.
I do know that you can back up log files when people are
connected (I do this every hour with our production
database) but once a week I perform a backup of all our
databases with all sort of integrity checks, re builds of
indexes and so on. Its these back ups the log file back
ups are failing on.
Thanks
Peter
>--Original Message--
>Dear All,
>My nightly backups for log files are failing as there are
>users still attached to the database being backup up.
>What is the best stratergy for dealing with this ?
>Do I
>1) Make the DB single user ?
>2) Have a script to kill all connections
>3) Modify my backup plans
>4) Some other
>Any help here would be greatly appriciated.
>Peter
>.
>|||How do you know that they are failing because users are attached? Where are
you getting these error messages from ?
What is the exact message from the Maintenance plan history ?
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Peter" <nospam@.thisemailaddress.co.uk> wrote in message
news:060601c35fee$5e973990$a101280a@.phx.gbl...
> Hello,
> Thanks for both of your replies.
> I am using SQL 2000. However the backups I am doing are
> part of the database maintence plan backups.
> I do know that you can back up log files when people are
> connected (I do this every hour with our production
> database) but once a week I perform a backup of all our
> databases with all sort of integrity checks, re builds of
> indexes and so on. Its these back ups the log file back
> ups are failing on.
> Thanks
> Peter
> >--Original Message--
> >Dear All,
> >
> >My nightly backups for log files are failing as there are
> >users still attached to the database being backup up.
> >
> >What is the best stratergy for dealing with this ?
> >
> >Do I
> >1) Make the DB single user ?
> >2) Have a script to kill all connections
> >3) Modify my backup plans
> >4) Some other
> >
> >Any help here would be greatly appriciated.
> >
> >Peter
> >.
> >

Backup Microsoft SQL server desktop engine 8.00.761

Dear Sirs.
I'm not an expert on SQL, and have a few questions. A friend has installed a
software using Microsoft SQL server desktop engine 8.00.761, and i'm trying
to help him setting up a backup to disk for him. The software using sql is a
commercial, with very poor builtin backup system. It's an economy software,
and You need to make backup of each firm manually 1 by 1, and when You have
600+ companies this isn't acceptable. I'd like to set up an automatical
backup (Full) to disk each night, i've set up a rotating swapping of external
disk system for him. I've noticed that when ever he adds a new company to
the SQL database, a new table under USER is added. Any tips on any simple
software that can be used? Does Microsoft SQL server desktop engine 8.00.761
have any built in backup features? Can i install to Microsoft SQL Express
2005 and try to get the SQL database working with that?
I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
minutes to backup a database consisting of 570MB data, is this normal?
With regards
Erling HerstadPlease try Using
Litespeed and SQL backtrack from BMC software.
Thanks
Ajay Rengunthwar
MCTS
On Feb 26, 4:38=A0am, Erling Herstad
<ErlingHers...@.discussions.microsoft.com> wrote:
> Dear Sirs.
> I'm not an expert on SQL, and have a few questions. A friend has installed= a
> software using Microsoft SQL server desktop engine =A0 8.00.761, and i'm t=rying
> to help him setting up a backup to disk for him. The software using sql is= a
> commercial, with very poor builtin backup system. It's an economy software=,
> and You need to make backup of each firm manually 1 by 1, and when You hav=e
> 600+ companies this isn't acceptable. I'd like to set up an automatical
> backup (Full) to disk each night, i've set up a rotating swapping of exter=nal
> disk system for him. =A0I've noticed that when ever he adds a new company =to
> the SQL database, a new table under USER is added. Any tips on any simple
> software that can be used? Does Microsoft SQL server desktop engine 8.00.7=61
> have any built in backup features? Can i install to Microsoft SQL Express
> 2005 and try to get the SQL database working with that?
> I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> minutes to backup a database consisting of 570MB data, is this normal?
> With regards
> Erling Herstad|||You can use the the native backup commands. You can install the client tools
and connect to it to use the GUI to set up jobs. Also, you ought apply SP4.
That is the RTM version and is open to the slammer worm.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Erling Herstad" <ErlingHerstad@.discussions.microsoft.com> wrote in message
news:6E7DC668-A458-463C-8AF7-D54C3A842410@.microsoft.com...
> Dear Sirs.
> I'm not an expert on SQL, and have a few questions. A friend has installed
> a
> software using Microsoft SQL server desktop engine 8.00.761, and i'm
> trying
> to help him setting up a backup to disk for him. The software using sql is
> a
> commercial, with very poor builtin backup system. It's an economy
> software,
> and You need to make backup of each firm manually 1 by 1, and when You
> have
> 600+ companies this isn't acceptable. I'd like to set up an automatical
> backup (Full) to disk each night, i've set up a rotating swapping of
> external
> disk system for him. I've noticed that when ever he adds a new company to
> the SQL database, a new table under USER is added. Any tips on any simple
> software that can be used? Does Microsoft SQL server desktop engine
> 8.00.761
> have any built in backup features? Can i install to Microsoft SQL Express
> 2005 and try to get the SQL database working with that?
> I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> minutes to backup a database consisting of 570MB data, is this normal?
> With regards
> Erling Herstad
>|||Hi.
i'll have a look into the software you suggested.
"Ajay Rengunthwar" wrote:
> Please try Using
> Litespeed and SQL backtrack from BMC software.
>
> Thanks
> Ajay Rengunthwar
> MCTS
> On Feb 26, 4:38 am, Erling Herstad
> <ErlingHers...@.discussions.microsoft.com> wrote:
> > Dear Sirs.
> >
> > I'm not an expert on SQL, and have a few questions. A friend has installed a
> > software using Microsoft SQL server desktop engine 8.00.761, and i'm trying
> > to help him setting up a backup to disk for him. The software using sql is a
> > commercial, with very poor builtin backup system. It's an economy software,
> > and You need to make backup of each firm manually 1 by 1, and when You have
> > 600+ companies this isn't acceptable. I'd like to set up an automatical
> > backup (Full) to disk each night, i've set up a rotating swapping of external
> > disk system for him. I've noticed that when ever he adds a new company to
> > the SQL database, a new table under USER is added. Any tips on any simple
> > software that can be used? Does Microsoft SQL server desktop engine 8.00.761
> > have any built in backup features? Can i install to Microsoft SQL Express
> > 2005 and try to get the SQL database working with that?
> > I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> > minutes to backup a database consisting of 570MB data, is this normal?
> >
> > With regards
> > Erling Herstad
>|||Hi.
Do You have a link for the Client tools? And a link to SP4?
"jason" wrote:
> You can use the the native backup commands. You can install the client tools
> and connect to it to use the GUI to set up jobs. Also, you ought apply SP4.
> That is the RTM version and is open to the slammer worm.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "Erling Herstad" <ErlingHerstad@.discussions.microsoft.com> wrote in message
> news:6E7DC668-A458-463C-8AF7-D54C3A842410@.microsoft.com...
> > Dear Sirs.
> >
> > I'm not an expert on SQL, and have a few questions. A friend has installed
> > a
> > software using Microsoft SQL server desktop engine 8.00.761, and i'm
> > trying
> > to help him setting up a backup to disk for him. The software using sql is
> > a
> > commercial, with very poor builtin backup system. It's an economy
> > software,
> > and You need to make backup of each firm manually 1 by 1, and when You
> > have
> > 600+ companies this isn't acceptable. I'd like to set up an automatical
> > backup (Full) to disk each night, i've set up a rotating swapping of
> > external
> > disk system for him. I've noticed that when ever he adds a new company to
> > the SQL database, a new table under USER is added. Any tips on any simple
> > software that can be used? Does Microsoft SQL server desktop engine
> > 8.00.761
> > have any built in backup features? Can i install to Microsoft SQL Express
> > 2005 and try to get the SQL database working with that?
> > I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> > minutes to backup a database consisting of 570MB data, is this normal?
> >
> > With regards
> > Erling Herstad
> >
>

Backup Microsoft SQL server desktop engine 8.00.761

Dear Sirs.
I'm not an expert on SQL, and have a few questions. A friend has installed a
software using Microsoft SQL server desktop engine 8.00.761, and i'm trying
to help him setting up a backup to disk for him. The software using sql is a
commercial, with very poor builtin backup system. It's an economy software,
and You need to make backup of each firm manually 1 by 1, and when You have
600+ companies this isn't acceptable. I'd like to set up an automatical
backup (Full) to disk each night, i've set up a rotating swapping of external
disk system for him. I've noticed that when ever he adds a new company to
the SQL database, a new table under USER is added. Any tips on any simple
software that can be used? Does Microsoft SQL server desktop engine 8.00.761
have any built in backup features? Can i install to Microsoft SQL Express
2005 and try to get the SQL database working with that?
I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
minutes to backup a database consisting of 570MB data, is this normal?
With regards
Erling Herstad
Please try Using
Litespeed and SQL backtrack from BMC software.
Thanks
Ajay Rengunthwar
MCTS
On Feb 26, 4:38Xam, Erling Herstad
<ErlingHers...@.discussions.microsoft.com> wrote:
> Dear Sirs.
> I'm not an expert on SQL, and have a few questions. A friend has installeda
> software using Microsoft SQL server desktop engine X 8.00.761, and i'm trying
> to help him setting up a backup to disk for him. The software using sql isa
> commercial, with very poor builtin backup system. It's an economy software,
> and You need to make backup of each firm manually 1 by 1, and when You have
> 600+ companies this isn't acceptable. I'd like to set up an automatical
> backup (Full) to disk each night, i've set up a rotating swapping of external
> disk system for him. XI've noticed that when ever he adds a new company to
> the SQL database, a new table under USER is added. Any tips on any simple
> software that can be used? Does Microsoft SQL server desktop engine 8.00.761
> have any built in backup features? Can i install to Microsoft SQL Express
> 2005 and try to get the SQL database working with that?
> I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> minutes to backup a database consisting of 570MB data, is this normal?
> With regards
> Erling Herstad
|||You can use the the native backup commands. You can install the client tools
and connect to it to use the GUI to set up jobs. Also, you ought apply SP4.
That is the RTM version and is open to the slammer worm.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Erling Herstad" <ErlingHerstad@.discussions.microsoft.com> wrote in message
news:6E7DC668-A458-463C-8AF7-D54C3A842410@.microsoft.com...
> Dear Sirs.
> I'm not an expert on SQL, and have a few questions. A friend has installed
> a
> software using Microsoft SQL server desktop engine 8.00.761, and i'm
> trying
> to help him setting up a backup to disk for him. The software using sql is
> a
> commercial, with very poor builtin backup system. It's an economy
> software,
> and You need to make backup of each firm manually 1 by 1, and when You
> have
> 600+ companies this isn't acceptable. I'd like to set up an automatical
> backup (Full) to disk each night, i've set up a rotating swapping of
> external
> disk system for him. I've noticed that when ever he adds a new company to
> the SQL database, a new table under USER is added. Any tips on any simple
> software that can be used? Does Microsoft SQL server desktop engine
> 8.00.761
> have any built in backup features? Can i install to Microsoft SQL Express
> 2005 and try to get the SQL database working with that?
> I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> minutes to backup a database consisting of 570MB data, is this normal?
> With regards
> Erling Herstad
>
|||Hi.
Do You have a link for the Client tools? And a link to SP4?
"jason" wrote:

> You can use the the native backup commands. You can install the client tools
> and connect to it to use the GUI to set up jobs. Also, you ought apply SP4.
> That is the RTM version and is open to the slammer worm.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "Erling Herstad" <ErlingHerstad@.discussions.microsoft.com> wrote in message
> news:6E7DC668-A458-463C-8AF7-D54C3A842410@.microsoft.com...
>
|||Hi.
i'll have a look into the software you suggested.
"Ajay Rengunthwar" wrote:

> Please try Using
> Litespeed and SQL backtrack from BMC software.
>
> Thanks
> Ajay Rengunthwar
> MCTS
> On Feb 26, 4:38 am, Erling Herstad
> <ErlingHers...@.discussions.microsoft.com> wrote:
>

Backup job Fails every time:

Dear Friends!
I have a scheduled job on my production server which always fails. When I
see the job history step details I can see 100 % backedup and along with
that I receive error
[SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
step failed.
Pl, guide me. Job fail isn't affordable on my production database.
I sincerly thank you!
S.Lakshminarayanan.
Message posted via http://www.sqlmonster.com
Can you try issuing a BACKUP DATABASE statement via T-SQL through Query
Analyzer? It would be helpful to see the errors (if there are any). Before
running the backup make sure that you have results set to text.
The syntax is easy enough:
BACKUP DATABASE SLNKMIL TO DISK = 'x:\SLNKMIL.bak' WITH INIT
Keith
"lakshminarayan iyer via SQLMonster.com" <forum@.SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@.SQLMonster.c om...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database
'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
> Pl, guide me. Job fail isn't affordable on my production database.
> I sincerly thank you!
> S.Lakshminarayanan.
> --
> Message posted via http://www.sqlmonster.com
|||Is the database in Simple recovery mode? If so you can not do a log backup.
Andrew J. Kelly SQL MVP
"lakshminarayan iyer via SQLMonster.com" <forum@.SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@.SQLMonster.c om...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
> Pl, guide me. Job fail isn't affordable on my production database.
> I sincerly thank you!
> S.Lakshminarayanan.
> --
> Message posted via http://www.sqlmonster.com