hi Friends,
How r u' i'll need some help from your end about sql2000 server.
i'll made a job for database backup. In this backup job append the
backupfile day by day. It is working for some day but after some day.
This job will be fail. It's shows me "file is incorrectly formatted.
Backups cannot be appended, but existing backup sets may still be
usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
Please help me
Thanks & Regards,
Rohit Taru.
*** Sent via Developersdex http://www.developersdex.com ***Hi
"rohit taru" wrote:
>
> hi Friends,
> How r u' i'll need some help from your end about sql2000 server.
> i'll made a job for database backup. In this backup job append the
> backupfile day by day. It is working for some day but after some day.
> This job will be fail. It's shows me "file is incorrectly formatted.
> Backups cannot be appended, but existing backup sets may still be
> usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
> abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
> Please help me
>
> Thanks & Regards,
> Rohit Taru.
>
Check out
http://support.microsoft.com/default.aspx/kb/290787
John
Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts
Tuesday, March 27, 2012
Backup fail
hi Friends,
How r u? i'll need some help from your end about sql2000 server.
i'll made a job for database backup. In this backup job append the
backupfile day by day. It is working for some day but after some day.
This job will be fail. It's shows me "file is incorrectly formatted.
Backups cannot be appended, but existing backup sets may still be
usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
Please help me
Thanks & Regards,
Rohit Taru.
*** Sent via Developersdex http://www.codecomments.com ***
Hi
"rohit taru" wrote:
>
> hi Friends,
> How r u? i'll need some help from your end about sql2000 server.
> i'll made a job for database backup. In this backup job append the
> backupfile day by day. It is working for some day but after some day.
> This job will be fail. It's shows me "file is incorrectly formatted.
> Backups cannot be appended, but existing backup sets may still be
> usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
> abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
> Please help me
>
> Thanks & Regards,
> Rohit Taru.
>
Check out
http://support.microsoft.com/default.aspx/kb/290787
John
How r u? i'll need some help from your end about sql2000 server.
i'll made a job for database backup. In this backup job append the
backupfile day by day. It is working for some day but after some day.
This job will be fail. It's shows me "file is incorrectly formatted.
Backups cannot be appended, but existing backup sets may still be
usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
Please help me
Thanks & Regards,
Rohit Taru.
*** Sent via Developersdex http://www.codecomments.com ***
Hi
"rohit taru" wrote:
>
> hi Friends,
> How r u? i'll need some help from your end about sql2000 server.
> i'll made a job for database backup. In this backup job append the
> backupfile day by day. It is working for some day but after some day.
> This job will be fail. It's shows me "file is incorrectly formatted.
> Backups cannot be appended, but existing backup sets may still be
> usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
> abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
> Please help me
>
> Thanks & Regards,
> Rohit Taru.
>
Check out
http://support.microsoft.com/default.aspx/kb/290787
John
Backup fail
hi Friends,
How r u' i'll need some help from your end about sql2000 server.
i'll made a job for database backup. In this backup job append the
backupfile day by day. It is working for some day but after some day.
This job will be fail. It's shows me "file is incorrectly formatted.
Backups cannot be appended, but existing backup sets may still be
usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
Please help me
Thanks & Regards,
Rohit Taru.
*** Sent via Developersdex http://www.codecomments.com ***Hi
"rohit taru" wrote:
>
> hi Friends,
> How r u' i'll need some help from your end about sql2000 server.
> i'll made a job for database backup. In this backup job append the
> backupfile day by day. It is working for some day but after some day.
> This job will be fail. It's shows me "file is incorrectly formatted.
> Backups cannot be appended, but existing backup sets may still be
> usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
> abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
> Please help me
>
> Thanks & Regards,
> Rohit Taru.
>
Check out
http://support.microsoft.com/default.aspx/kb/290787
John
How r u' i'll need some help from your end about sql2000 server.
i'll made a job for database backup. In this backup job append the
backupfile day by day. It is working for some day but after some day.
This job will be fail. It's shows me "file is incorrectly formatted.
Backups cannot be appended, but existing backup sets may still be
usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
Please help me
Thanks & Regards,
Rohit Taru.
*** Sent via Developersdex http://www.codecomments.com ***Hi
"rohit taru" wrote:
>
> hi Friends,
> How r u' i'll need some help from your end about sql2000 server.
> i'll made a job for database backup. In this backup job append the
> backupfile day by day. It is working for some day but after some day.
> This job will be fail. It's shows me "file is incorrectly formatted.
> Backups cannot be appended, but existing backup sets may still be
> usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating
> abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
> Please help me
>
> Thanks & Regards,
> Rohit Taru.
>
Check out
http://support.microsoft.com/default.aspx/kb/290787
John
Sunday, March 25, 2012
Backup everything except data
We have a SQL2000 database that is created via a dump from a third party
product. Being as this dump runs every day, we don't need to back up the
data. However we need the schema, views, triggers, etc. Everything except
the actual data in the tables. Is there a way to make a backup of this?
Thanks!
BrianYes, use some tool that generates DDL script for the database:
http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian" <me@.here.there> wrote in message news:O%2323gnK8HHA.484@.TK2MSFTNGP06.phx.gbl...
> We have a SQL2000 database that is created via a dump from a third party product. Being as this
> dump runs every day, we don't need to back up the data. However we need the schema, views,
> triggers, etc. Everything except the actual data in the tables. Is there a way to make a backup of
> this?
> Thanks!
> Brian
>
product. Being as this dump runs every day, we don't need to back up the
data. However we need the schema, views, triggers, etc. Everything except
the actual data in the tables. Is there a way to make a backup of this?
Thanks!
BrianYes, use some tool that generates DDL script for the database:
http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian" <me@.here.there> wrote in message news:O%2323gnK8HHA.484@.TK2MSFTNGP06.phx.gbl...
> We have a SQL2000 database that is created via a dump from a third party product. Being as this
> dump runs every day, we don't need to back up the data. However we need the schema, views,
> triggers, etc. Everything except the actual data in the tables. Is there a way to make a backup of
> this?
> Thanks!
> Brian
>
Backup Error: sql-dom sql state 4200
When trying to backup a sql2000 database I receive the following error:
"Microsoft SQL-DOM (odbc sqlstate: 42000)
The Volume on device xxx e:\backupfilename.bak belongs to a different media set.
Backup or restore operation terminating abnormally."
Thanks for any help,
JimIf you have no use for the existing backup file, you could
either delete the file from the file system before doing
the backup or add the FORMAT option to the BACKUP
statement.
Linchi
>--Original Message--
>When trying to backup a sql2000 database I receive the
following error:
>"Microsoft SQL-DOM (odbc sqlstate: 42000)
>The Volume on device xxx e:\backupfilename.bak belongs to
a different media set.
>Backup or restore operation terminating abnormally."
>Thanks for any help,
>Jim
>
>.
>
"Microsoft SQL-DOM (odbc sqlstate: 42000)
The Volume on device xxx e:\backupfilename.bak belongs to a different media set.
Backup or restore operation terminating abnormally."
Thanks for any help,
JimIf you have no use for the existing backup file, you could
either delete the file from the file system before doing
the backup or add the FORMAT option to the BACKUP
statement.
Linchi
>--Original Message--
>When trying to backup a sql2000 database I receive the
following error:
>"Microsoft SQL-DOM (odbc sqlstate: 42000)
>The Volume on device xxx e:\backupfilename.bak belongs to
a different media set.
>Backup or restore operation terminating abnormally."
>Thanks for any help,
>Jim
>
>.
>
Monday, March 19, 2012
Backup Databases
I am running SQL2000 SP4 on a Win2000 server and getting following error when
trying to perform a backup of a database within Enterprise Manager.
"Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
references. Reason 127(The specified procedure could not be found.). I have
looked any references to this error message, but yet to find anything on it.
Wondering if someone can assist me.
thanks,
JayHi
If backing up the datrabase from a different PC works, then I would think
re-installing the client tools may help solve this.
John
"Jay" wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error when
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I have
> looked any references to this error message, but yet to find anything on it.
> Wondering if someone can assist me.
> thanks,
> Jay
>|||Jay wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error when
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I have
> looked any references to this error message, but yet to find anything on it.
> Wondering if someone can assist me.
> thanks,
> Jay
>
Open up Query Analyzer and use the T-SQL BACKUP command - does it work?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
trying to perform a backup of a database within Enterprise Manager.
"Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
references. Reason 127(The specified procedure could not be found.). I have
looked any references to this error message, but yet to find anything on it.
Wondering if someone can assist me.
thanks,
JayHi
If backing up the datrabase from a different PC works, then I would think
re-installing the client tools may help solve this.
John
"Jay" wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error when
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I have
> looked any references to this error message, but yet to find anything on it.
> Wondering if someone can assist me.
> thanks,
> Jay
>|||Jay wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error when
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I have
> looked any references to this error message, but yet to find anything on it.
> Wondering if someone can assist me.
> thanks,
> Jay
>
Open up Query Analyzer and use the T-SQL BACKUP command - does it work?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Backup Databases
I am running SQL2000 SP4 on a Win2000 server and getting following error whe
n
trying to perform a backup of a database within Enterprise Manager.
"Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
references. Reason 127(The specified procedure could not be found.). I have
looked any references to this error message, but yet to find anything on it.
Wondering if someone can assist me.
thanks,
JayHi
If backing up the datrabase from a different PC works, then I would think
re-installing the client tools may help solve this.
John
"Jay" wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error w
hen
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I ha
ve
> looked any references to this error message, but yet to find anything on i
t.
> Wondering if someone can assist me.
> thanks,
> Jay
>|||Jay wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error w
hen
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I ha
ve
> looked any references to this error message, but yet to find anything on i
t.
> Wondering if someone can assist me.
> thanks,
> Jay
>
Open up Query Analyzer and use the T-SQL BACKUP command - does it work?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
n
trying to perform a backup of a database within Enterprise Manager.
"Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
references. Reason 127(The specified procedure could not be found.). I have
looked any references to this error message, but yet to find anything on it.
Wondering if someone can assist me.
thanks,
JayHi
If backing up the datrabase from a different PC works, then I would think
re-installing the client tools may help solve this.
John
"Jay" wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error w
hen
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I ha
ve
> looked any references to this error message, but yet to find anything on i
t.
> Wondering if someone can assist me.
> thanks,
> Jay
>|||Jay wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error w
hen
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I ha
ve
> looked any references to this error message, but yet to find anything on i
t.
> Wondering if someone can assist me.
> thanks,
> Jay
>
Open up Query Analyzer and use the T-SQL BACKUP command - does it work?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Friday, February 24, 2012
Backup and Move
SQL Nubie need to accomplish two things. 1. backup an SQL2000 db on old hardware. 2. Use backup to build same SQL2000 db onto new hardware, which will replace old hardware as main system. Running Win2000 server standard edition on old server and Win2003 server standard edition on new server. Old server does not have a tape backup, but it has a cd burner and access to a Novell corparate network -without any established Windows domains. Asking for much, hope someone can help. Some source material would go along way. ThanksDump the databases in a local file on your harddisk, using backup SQL statement.
Bcp out the main tables of the master DB.
Copy all these files into your CD and tranfer them in the new hardware.
Recreate a new MS-SQL server in the new machine
do you keep the original tree-architecture in your both machines ?
Bcp out the main tables of the master DB.
Copy all these files into your CD and tranfer them in the new hardware.
Recreate a new MS-SQL server in the new machine
do you keep the original tree-architecture in your both machines ?
Sunday, February 19, 2012
backup (SQL2000)/restore (SQL2005) problem in details
Sorry, I have to give more detail about my question.
I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in database: machine_name\my_login_name. OS: 2000server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same name DB. Auto
generated the user list which is same as in original database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the node databases: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I can not either show the diagram or create a new diagram on this restored
database DB.
I do not know the detail steps for doing it. MSDN articles suggest that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
(It is OK for me to exec. it)
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to new
which produced:
"Msg 15151, Level 16, State 1, Line 1
Cannot find the principal 'new', because it does not exist or you do not
have permission."
I have trouble here. I do not know how to do it. Did I do something wrong?
What is the correct way/steps?
Are there any tricks in backup and restore process?
Thank you for any help.
David
Did you copy the user accounts and logins from SQL Server 2000 to 2005?
"david" <david@.discussions.microsoft.com> wrote in message
news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some
> people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB.
> Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this
> database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog
> box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
|||Hi David
Could you go to Microsoft SQL Server Management Studio and see under the
Security section of the SQL Server itself (not the database), and see if you
have any of the users in that one correspond/mapped to the database user?
My guess is that if you are only backup and restore the user database, it
will not carry the login information which is stored in system database.
Have you tried to log on as an sa (if it is on mixed mode) and tried to do
the things that you wanted to do?
Lucas
"david" wrote:
[vbcol=seagreen]
> NO, I did not copy user accounts and logins from SQL Server 2000.
> When I made a backup with COMPLETE option, the backup carry all information
> about the database. When I restored the database, all accounts and sttatus
> for old machine automatically appear in the user list for the restored
> database under SQL Server 2005 on new machine.
> David
>
> "bass_player [SBS-MVP]" wrote:
I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in database: machine_name\my_login_name. OS: 2000server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same name DB. Auto
generated the user list which is same as in original database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the node databases: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I can not either show the diagram or create a new diagram on this restored
database DB.
I do not know the detail steps for doing it. MSDN articles suggest that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
(It is OK for me to exec. it)
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to new
which produced:
"Msg 15151, Level 16, State 1, Line 1
Cannot find the principal 'new', because it does not exist or you do not
have permission."
I have trouble here. I do not know how to do it. Did I do something wrong?
What is the correct way/steps?
Are there any tricks in backup and restore process?
Thank you for any help.
David
Did you copy the user accounts and logins from SQL Server 2000 to 2005?
"david" <david@.discussions.microsoft.com> wrote in message
news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some
> people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB.
> Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this
> database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog
> box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
|||Hi David
Could you go to Microsoft SQL Server Management Studio and see under the
Security section of the SQL Server itself (not the database), and see if you
have any of the users in that one correspond/mapped to the database user?
My guess is that if you are only backup and restore the user database, it
will not carry the login information which is stored in system database.
Have you tried to log on as an sa (if it is on mixed mode) and tried to do
the things that you wanted to do?
Lucas
"david" wrote:
[vbcol=seagreen]
> NO, I did not copy user accounts and logins from SQL Server 2000.
> When I made a backup with COMPLETE option, the backup carry all information
> about the database. When I restored the database, all accounts and sttatus
> for old machine automatically appear in the user list for the restored
> database under SQL Server 2005 on new machine.
> David
>
> "bass_player [SBS-MVP]" wrote:
backup (SQL2000)/restore (SQL2005) problem in details
Sorry, I have to give more detail about my question.
I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in database: machine_name\my_login_name. OS: 2000server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same name DB. Auto
generated the user list which is same as in original database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the node databases: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I can not either show the diagram or create a new diagram on this restored
database DB.
I do not know the detail steps for doing it. MSDN articles suggest that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
(It is OK for me to exec. it)
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to new
which produced:
"Msg 15151, Level 16, State 1, Line 1
Cannot find the principal 'new', because it does not exist or you do not
have permission."
I have trouble here. I do not know how to do it. Did I do something wrong?
What is the correct way/steps?
Are there any tricks in backup and restore process?
Thank you for any help.
DavidDid you copy the user accounts and logins from SQL Server 2000 to 2005?
"david" <david@.discussions.microsoft.com> wrote in message
news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some
> people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB.
> Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this
> database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog
> box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>|||NO, I did not copy user accounts and logins from SQL Server 2000.
When I made a backup with COMPLETE option, the backup carry all information
about the database. When I restored the database, all accounts and sttatus
for old machine automatically appear in the user list for the restored
database under SQL Server 2005 on new machine.
David
"bass_player [SBS-MVP]" wrote:
> Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> "david" <david@.discussions.microsoft.com> wrote in message
> news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > Sorry, I have to give more detail about my question.
> > I have trouble with it. I have tried several ways and talked to some
> > people
> > in the forum, but it is not working. The following is waht I did.
> >
> > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > and my login name in database: machine_name\my_login_name. OS: 2000server
> > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > (3) Start SQL Server Management Studio of SQL Server 2005.
> > (4) Use Restore to restore the backup to a database with same name DB.
> > Auto
> > generated the user list which is same as in original database server: dbo
> > (owner), guest, ASPNET and so on. My login name in new server machine,
> > displayed in security under the node databases: nwe_machine_name\new
> > loginname (has a space between two words).
> > (5)Now I add new user to the stored database DB:
> > Expand Security under DB.
> > Rigth click on Users and select new user. Dialog pop up.
> > Broswer Login Name: nwe_machine_name\new loginname
> > Type in user name: new
> > Browser default schema: db_owner
> > Select Database Role Menbership: db_owner
> > Click OK.
> >
> > User new is added in the list.
> >
> >
> >
> > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > work. When I click the tree node Database Diagrams, I get
> > the error massage. I can not either display the diagram or create new
> > diagram on the database. The error message:
> > "Database diagram support objects cannot be installed because this
> > database
> > does not have valid owner.
> > To continue, first use the Files page of the Database Properties dialog
> > box
> > ot the Alter Authorization statement
> > to set the database owner to a valid login, then add the datatbase diagram
> > support objects."
> >
> > I can not either show the diagram or create a new diagram on this restored
> > database DB.
> >
> > I do not know the detail steps for doing it. MSDN articles suggest that
> > For compatiable, run
> > exec sp_dbcmptlevel 'database_name', '90';
> > (It is OK for me to exec. it)
> >
> > For alter authorization, run
> > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > which produced:
> > "Msg 15151, Level 16, State 1, Line 1
> > Cannot find the principal 'new', because it does not exist or you do not
> > have permission."
> >
> > I have trouble here. I do not know how to do it. Did I do something wrong?
> > What is the correct way/steps?
> > Are there any tricks in backup and restore process?
> >
> > Thank you for any help.
> >
> > David
> >
>
>|||Hi David
Could you go to Microsoft SQL Server Management Studio and see under the
Security section of the SQL Server itself (not the database), and see if you
have any of the users in that one correspond/mapped to the database user?
My guess is that if you are only backup and restore the user database, it
will not carry the login information which is stored in system database.
Have you tried to log on as an sa (if it is on mixed mode) and tried to do
the things that you wanted to do?
Lucas
"david" wrote:
> NO, I did not copy user accounts and logins from SQL Server 2000.
> When I made a backup with COMPLETE option, the backup carry all information
> about the database. When I restored the database, all accounts and sttatus
> for old machine automatically appear in the user list for the restored
> database under SQL Server 2005 on new machine.
> David
>
> "bass_player [SBS-MVP]" wrote:
> > Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> >
> > "david" <david@.discussions.microsoft.com> wrote in message
> > news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > > Sorry, I have to give more detail about my question.
> > > I have trouble with it. I have tried several ways and talked to some
> > > people
> > > in the forum, but it is not working. The following is waht I did.
> > >
> > > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > > and my login name in database: machine_name\my_login_name. OS: 2000server
> > > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > > (3) Start SQL Server Management Studio of SQL Server 2005.
> > > (4) Use Restore to restore the backup to a database with same name DB.
> > > Auto
> > > generated the user list which is same as in original database server: dbo
> > > (owner), guest, ASPNET and so on. My login name in new server machine,
> > > displayed in security under the node databases: nwe_machine_name\new
> > > loginname (has a space between two words).
> > > (5)Now I add new user to the stored database DB:
> > > Expand Security under DB.
> > > Rigth click on Users and select new user. Dialog pop up.
> > > Broswer Login Name: nwe_machine_name\new loginname
> > > Type in user name: new
> > > Browser default schema: db_owner
> > > Select Database Role Menbership: db_owner
> > > Click OK.
> > >
> > > User new is added in the list.
> > >
> > >
> > >
> > > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > > work. When I click the tree node Database Diagrams, I get
> > > the error massage. I can not either display the diagram or create new
> > > diagram on the database. The error message:
> > > "Database diagram support objects cannot be installed because this
> > > database
> > > does not have valid owner.
> > > To continue, first use the Files page of the Database Properties dialog
> > > box
> > > ot the Alter Authorization statement
> > > to set the database owner to a valid login, then add the datatbase diagram
> > > support objects."
> > >
> > > I can not either show the diagram or create a new diagram on this restored
> > > database DB.
> > >
> > > I do not know the detail steps for doing it. MSDN articles suggest that
> > > For compatiable, run
> > > exec sp_dbcmptlevel 'database_name', '90';
> > > (It is OK for me to exec. it)
> > >
> > > For alter authorization, run
> > > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > > which produced:
> > > "Msg 15151, Level 16, State 1, Line 1
> > > Cannot find the principal 'new', because it does not exist or you do not
> > > have permission."
> > >
> > > I have trouble here. I do not know how to do it. Did I do something wrong?
> > > What is the correct way/steps?
> > > Are there any tricks in backup and restore process?
> > >
> > > Thank you for any help.
> > >
> > > David
> > >
> >
> >
> >|||Thank you.
Could you tell me the correct way for backup the database in SQL Server 2000?
Dabin
"Lucas Kartawidjaja" wrote:
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if you
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
> > NO, I did not copy user accounts and logins from SQL Server 2000.
> > When I made a backup with COMPLETE option, the backup carry all information
> > about the database. When I restored the database, all accounts and sttatus
> > for old machine automatically appear in the user list for the restored
> > database under SQL Server 2005 on new machine.
> >
> > David
> >
> >
> > "bass_player [SBS-MVP]" wrote:
> >
> > > Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> > >
> > > "david" <david@.discussions.microsoft.com> wrote in message
> > > news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > > > Sorry, I have to give more detail about my question.
> > > > I have trouble with it. I have tried several ways and talked to some
> > > > people
> > > > in the forum, but it is not working. The following is waht I did.
> > > >
> > > > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > > > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > > > and my login name in database: machine_name\my_login_name. OS: 2000server
> > > > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > > > (3) Start SQL Server Management Studio of SQL Server 2005.
> > > > (4) Use Restore to restore the backup to a database with same name DB.
> > > > Auto
> > > > generated the user list which is same as in original database server: dbo
> > > > (owner), guest, ASPNET and so on. My login name in new server machine,
> > > > displayed in security under the node databases: nwe_machine_name\new
> > > > loginname (has a space between two words).
> > > > (5)Now I add new user to the stored database DB:
> > > > Expand Security under DB.
> > > > Rigth click on Users and select new user. Dialog pop up.
> > > > Broswer Login Name: nwe_machine_name\new loginname
> > > > Type in user name: new
> > > > Browser default schema: db_owner
> > > > Select Database Role Menbership: db_owner
> > > > Click OK.
> > > >
> > > > User new is added in the list.
> > > >
> > > >
> > > >
> > > > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > > > work. When I click the tree node Database Diagrams, I get
> > > > the error massage. I can not either display the diagram or create new
> > > > diagram on the database. The error message:
> > > > "Database diagram support objects cannot be installed because this
> > > > database
> > > > does not have valid owner.
> > > > To continue, first use the Files page of the Database Properties dialog
> > > > box
> > > > ot the Alter Authorization statement
> > > > to set the database owner to a valid login, then add the datatbase diagram
> > > > support objects."
> > > >
> > > > I can not either show the diagram or create a new diagram on this restored
> > > > database DB.
> > > >
> > > > I do not know the detail steps for doing it. MSDN articles suggest that
> > > > For compatiable, run
> > > > exec sp_dbcmptlevel 'database_name', '90';
> > > > (It is OK for me to exec. it)
> > > >
> > > > For alter authorization, run
> > > > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > > > which produced:
> > > > "Msg 15151, Level 16, State 1, Line 1
> > > > Cannot find the principal 'new', because it does not exist or you do not
> > > > have permission."
> > > >
> > > > I have trouble here. I do not know how to do it. Did I do something wrong?
> > > > What is the correct way/steps?
> > > > Are there any tricks in backup and restore process?
> > > >
> > > > Thank you for any help.
> > > >
> > > > David
> > > >
> > >
> > >
> > >|||Sorry, some mistake in my description.
All users under databases should be under security of SQL Server. Restate as
follows:
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in security of server: machine_name\my_login_name. OS: Win
2000 server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same database name
DB. It Automatically
generated the user list (under DB) which is same as under DB in original
database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the SQL SERVER: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
"Lucas Kartawidjaja" wrote:
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if you
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
> > NO, I did not copy user accounts and logins from SQL Server 2000.
> > When I made a backup with COMPLETE option, the backup carry all information
> > about the database. When I restored the database, all accounts and sttatus
> > for old machine automatically appear in the user list for the restored
> > database under SQL Server 2005 on new machine.
> >
> > David
> >
> >
> > "bass_player [SBS-MVP]" wrote:
> >
> > > Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> > >
> > > "david" <david@.discussions.microsoft.com> wrote in message
> > > news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > > > Sorry, I have to give more detail about my question.
> > > > I have trouble with it. I have tried several ways and talked to some
> > > > people
> > > > in the forum, but it is not working. The following is waht I did.
> > > >
> > > > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > > > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > > > and my login name in database: machine_name\my_login_name. OS: 2000server
> > > > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > > > (3) Start SQL Server Management Studio of SQL Server 2005.
> > > > (4) Use Restore to restore the backup to a database with same name DB.
> > > > Auto
> > > > generated the user list which is same as in original database server: dbo
> > > > (owner), guest, ASPNET and so on. My login name in new server machine,
> > > > displayed in security under the node databases: nwe_machine_name\new
> > > > loginname (has a space between two words).
> > > > (5)Now I add new user to the stored database DB:
> > > > Expand Security under DB.
> > > > Rigth click on Users and select new user. Dialog pop up.
> > > > Broswer Login Name: nwe_machine_name\new loginname
> > > > Type in user name: new
> > > > Browser default schema: db_owner
> > > > Select Database Role Menbership: db_owner
> > > > Click OK.
> > > >
> > > > User new is added in the list.
> > > >
> > > >
> > > >
> > > > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > > > work. When I click the tree node Database Diagrams, I get
> > > > the error massage. I can not either display the diagram or create new
> > > > diagram on the database. The error message:
> > > > "Database diagram support objects cannot be installed because this
> > > > database
> > > > does not have valid owner.
> > > > To continue, first use the Files page of the Database Properties dialog
> > > > box
> > > > ot the Alter Authorization statement
> > > > to set the database owner to a valid login, then add the datatbase diagram
> > > > support objects."
> > > >
> > > > I can not either show the diagram or create a new diagram on this restored
> > > > database DB.
> > > >
> > > > I do not know the detail steps for doing it. MSDN articles suggest that
> > > > For compatiable, run
> > > > exec sp_dbcmptlevel 'database_name', '90';
> > > > (It is OK for me to exec. it)
> > > >
> > > > For alter authorization, run
> > > > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > > > which produced:
> > > > "Msg 15151, Level 16, State 1, Line 1
> > > > Cannot find the principal 'new', because it does not exist or you do not
> > > > have permission."
> > > >
> > > > I have trouble here. I do not know how to do it. Did I do something wrong?
> > > > What is the correct way/steps?
> > > > Are there any tricks in backup and restore process?
> > > >
> > > > Thank you for any help.
> > > >
> > > > David
> > > >
> > >
> > >
> > >|||Thank you, Player and Lucas:
It works now. Valid_login = "my machine\my login name" which is under sql
server\security\logins
David
"david" wrote:
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB. Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in database: machine_name\my_login_name. OS: 2000server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same name DB. Auto
generated the user list which is same as in original database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the node databases: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I can not either show the diagram or create a new diagram on this restored
database DB.
I do not know the detail steps for doing it. MSDN articles suggest that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
(It is OK for me to exec. it)
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to new
which produced:
"Msg 15151, Level 16, State 1, Line 1
Cannot find the principal 'new', because it does not exist or you do not
have permission."
I have trouble here. I do not know how to do it. Did I do something wrong?
What is the correct way/steps?
Are there any tricks in backup and restore process?
Thank you for any help.
DavidDid you copy the user accounts and logins from SQL Server 2000 to 2005?
"david" <david@.discussions.microsoft.com> wrote in message
news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some
> people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB.
> Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this
> database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog
> box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>|||NO, I did not copy user accounts and logins from SQL Server 2000.
When I made a backup with COMPLETE option, the backup carry all information
about the database. When I restored the database, all accounts and sttatus
for old machine automatically appear in the user list for the restored
database under SQL Server 2005 on new machine.
David
"bass_player [SBS-MVP]" wrote:
> Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> "david" <david@.discussions.microsoft.com> wrote in message
> news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > Sorry, I have to give more detail about my question.
> > I have trouble with it. I have tried several ways and talked to some
> > people
> > in the forum, but it is not working. The following is waht I did.
> >
> > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > and my login name in database: machine_name\my_login_name. OS: 2000server
> > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > (3) Start SQL Server Management Studio of SQL Server 2005.
> > (4) Use Restore to restore the backup to a database with same name DB.
> > Auto
> > generated the user list which is same as in original database server: dbo
> > (owner), guest, ASPNET and so on. My login name in new server machine,
> > displayed in security under the node databases: nwe_machine_name\new
> > loginname (has a space between two words).
> > (5)Now I add new user to the stored database DB:
> > Expand Security under DB.
> > Rigth click on Users and select new user. Dialog pop up.
> > Broswer Login Name: nwe_machine_name\new loginname
> > Type in user name: new
> > Browser default schema: db_owner
> > Select Database Role Menbership: db_owner
> > Click OK.
> >
> > User new is added in the list.
> >
> >
> >
> > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > work. When I click the tree node Database Diagrams, I get
> > the error massage. I can not either display the diagram or create new
> > diagram on the database. The error message:
> > "Database diagram support objects cannot be installed because this
> > database
> > does not have valid owner.
> > To continue, first use the Files page of the Database Properties dialog
> > box
> > ot the Alter Authorization statement
> > to set the database owner to a valid login, then add the datatbase diagram
> > support objects."
> >
> > I can not either show the diagram or create a new diagram on this restored
> > database DB.
> >
> > I do not know the detail steps for doing it. MSDN articles suggest that
> > For compatiable, run
> > exec sp_dbcmptlevel 'database_name', '90';
> > (It is OK for me to exec. it)
> >
> > For alter authorization, run
> > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > which produced:
> > "Msg 15151, Level 16, State 1, Line 1
> > Cannot find the principal 'new', because it does not exist or you do not
> > have permission."
> >
> > I have trouble here. I do not know how to do it. Did I do something wrong?
> > What is the correct way/steps?
> > Are there any tricks in backup and restore process?
> >
> > Thank you for any help.
> >
> > David
> >
>
>|||Hi David
Could you go to Microsoft SQL Server Management Studio and see under the
Security section of the SQL Server itself (not the database), and see if you
have any of the users in that one correspond/mapped to the database user?
My guess is that if you are only backup and restore the user database, it
will not carry the login information which is stored in system database.
Have you tried to log on as an sa (if it is on mixed mode) and tried to do
the things that you wanted to do?
Lucas
"david" wrote:
> NO, I did not copy user accounts and logins from SQL Server 2000.
> When I made a backup with COMPLETE option, the backup carry all information
> about the database. When I restored the database, all accounts and sttatus
> for old machine automatically appear in the user list for the restored
> database under SQL Server 2005 on new machine.
> David
>
> "bass_player [SBS-MVP]" wrote:
> > Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> >
> > "david" <david@.discussions.microsoft.com> wrote in message
> > news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > > Sorry, I have to give more detail about my question.
> > > I have trouble with it. I have tried several ways and talked to some
> > > people
> > > in the forum, but it is not working. The following is waht I did.
> > >
> > > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > > and my login name in database: machine_name\my_login_name. OS: 2000server
> > > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > > (3) Start SQL Server Management Studio of SQL Server 2005.
> > > (4) Use Restore to restore the backup to a database with same name DB.
> > > Auto
> > > generated the user list which is same as in original database server: dbo
> > > (owner), guest, ASPNET and so on. My login name in new server machine,
> > > displayed in security under the node databases: nwe_machine_name\new
> > > loginname (has a space between two words).
> > > (5)Now I add new user to the stored database DB:
> > > Expand Security under DB.
> > > Rigth click on Users and select new user. Dialog pop up.
> > > Broswer Login Name: nwe_machine_name\new loginname
> > > Type in user name: new
> > > Browser default schema: db_owner
> > > Select Database Role Menbership: db_owner
> > > Click OK.
> > >
> > > User new is added in the list.
> > >
> > >
> > >
> > > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > > work. When I click the tree node Database Diagrams, I get
> > > the error massage. I can not either display the diagram or create new
> > > diagram on the database. The error message:
> > > "Database diagram support objects cannot be installed because this
> > > database
> > > does not have valid owner.
> > > To continue, first use the Files page of the Database Properties dialog
> > > box
> > > ot the Alter Authorization statement
> > > to set the database owner to a valid login, then add the datatbase diagram
> > > support objects."
> > >
> > > I can not either show the diagram or create a new diagram on this restored
> > > database DB.
> > >
> > > I do not know the detail steps for doing it. MSDN articles suggest that
> > > For compatiable, run
> > > exec sp_dbcmptlevel 'database_name', '90';
> > > (It is OK for me to exec. it)
> > >
> > > For alter authorization, run
> > > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > > which produced:
> > > "Msg 15151, Level 16, State 1, Line 1
> > > Cannot find the principal 'new', because it does not exist or you do not
> > > have permission."
> > >
> > > I have trouble here. I do not know how to do it. Did I do something wrong?
> > > What is the correct way/steps?
> > > Are there any tricks in backup and restore process?
> > >
> > > Thank you for any help.
> > >
> > > David
> > >
> >
> >
> >|||Thank you.
Could you tell me the correct way for backup the database in SQL Server 2000?
Dabin
"Lucas Kartawidjaja" wrote:
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if you
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
> > NO, I did not copy user accounts and logins from SQL Server 2000.
> > When I made a backup with COMPLETE option, the backup carry all information
> > about the database. When I restored the database, all accounts and sttatus
> > for old machine automatically appear in the user list for the restored
> > database under SQL Server 2005 on new machine.
> >
> > David
> >
> >
> > "bass_player [SBS-MVP]" wrote:
> >
> > > Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> > >
> > > "david" <david@.discussions.microsoft.com> wrote in message
> > > news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > > > Sorry, I have to give more detail about my question.
> > > > I have trouble with it. I have tried several ways and talked to some
> > > > people
> > > > in the forum, but it is not working. The following is waht I did.
> > > >
> > > > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > > > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > > > and my login name in database: machine_name\my_login_name. OS: 2000server
> > > > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > > > (3) Start SQL Server Management Studio of SQL Server 2005.
> > > > (4) Use Restore to restore the backup to a database with same name DB.
> > > > Auto
> > > > generated the user list which is same as in original database server: dbo
> > > > (owner), guest, ASPNET and so on. My login name in new server machine,
> > > > displayed in security under the node databases: nwe_machine_name\new
> > > > loginname (has a space between two words).
> > > > (5)Now I add new user to the stored database DB:
> > > > Expand Security under DB.
> > > > Rigth click on Users and select new user. Dialog pop up.
> > > > Broswer Login Name: nwe_machine_name\new loginname
> > > > Type in user name: new
> > > > Browser default schema: db_owner
> > > > Select Database Role Menbership: db_owner
> > > > Click OK.
> > > >
> > > > User new is added in the list.
> > > >
> > > >
> > > >
> > > > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > > > work. When I click the tree node Database Diagrams, I get
> > > > the error massage. I can not either display the diagram or create new
> > > > diagram on the database. The error message:
> > > > "Database diagram support objects cannot be installed because this
> > > > database
> > > > does not have valid owner.
> > > > To continue, first use the Files page of the Database Properties dialog
> > > > box
> > > > ot the Alter Authorization statement
> > > > to set the database owner to a valid login, then add the datatbase diagram
> > > > support objects."
> > > >
> > > > I can not either show the diagram or create a new diagram on this restored
> > > > database DB.
> > > >
> > > > I do not know the detail steps for doing it. MSDN articles suggest that
> > > > For compatiable, run
> > > > exec sp_dbcmptlevel 'database_name', '90';
> > > > (It is OK for me to exec. it)
> > > >
> > > > For alter authorization, run
> > > > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > > > which produced:
> > > > "Msg 15151, Level 16, State 1, Line 1
> > > > Cannot find the principal 'new', because it does not exist or you do not
> > > > have permission."
> > > >
> > > > I have trouble here. I do not know how to do it. Did I do something wrong?
> > > > What is the correct way/steps?
> > > > Are there any tricks in backup and restore process?
> > > >
> > > > Thank you for any help.
> > > >
> > > > David
> > > >
> > >
> > >
> > >|||Sorry, some mistake in my description.
All users under databases should be under security of SQL Server. Restate as
follows:
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in security of server: machine_name\my_login_name. OS: Win
2000 server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same database name
DB. It Automatically
generated the user list (under DB) which is same as under DB in original
database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the SQL SERVER: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
"Lucas Kartawidjaja" wrote:
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if you
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
> > NO, I did not copy user accounts and logins from SQL Server 2000.
> > When I made a backup with COMPLETE option, the backup carry all information
> > about the database. When I restored the database, all accounts and sttatus
> > for old machine automatically appear in the user list for the restored
> > database under SQL Server 2005 on new machine.
> >
> > David
> >
> >
> > "bass_player [SBS-MVP]" wrote:
> >
> > > Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> > >
> > > "david" <david@.discussions.microsoft.com> wrote in message
> > > news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> > > > Sorry, I have to give more detail about my question.
> > > > I have trouble with it. I have tried several ways and talked to some
> > > > people
> > > > in the forum, but it is not working. The following is waht I did.
> > > >
> > > > (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> > > > COMPLETE backup setup, owners: dbo. Security:Windows mode
> > > > and my login name in database: machine_name\my_login_name. OS: 2000server
> > > > (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> > > > (3) Start SQL Server Management Studio of SQL Server 2005.
> > > > (4) Use Restore to restore the backup to a database with same name DB.
> > > > Auto
> > > > generated the user list which is same as in original database server: dbo
> > > > (owner), guest, ASPNET and so on. My login name in new server machine,
> > > > displayed in security under the node databases: nwe_machine_name\new
> > > > loginname (has a space between two words).
> > > > (5)Now I add new user to the stored database DB:
> > > > Expand Security under DB.
> > > > Rigth click on Users and select new user. Dialog pop up.
> > > > Broswer Login Name: nwe_machine_name\new loginname
> > > > Type in user name: new
> > > > Browser default schema: db_owner
> > > > Select Database Role Menbership: db_owner
> > > > Click OK.
> > > >
> > > > User new is added in the list.
> > > >
> > > >
> > > >
> > > > (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> > > > work. When I click the tree node Database Diagrams, I get
> > > > the error massage. I can not either display the diagram or create new
> > > > diagram on the database. The error message:
> > > > "Database diagram support objects cannot be installed because this
> > > > database
> > > > does not have valid owner.
> > > > To continue, first use the Files page of the Database Properties dialog
> > > > box
> > > > ot the Alter Authorization statement
> > > > to set the database owner to a valid login, then add the datatbase diagram
> > > > support objects."
> > > >
> > > > I can not either show the diagram or create a new diagram on this restored
> > > > database DB.
> > > >
> > > > I do not know the detail steps for doing it. MSDN articles suggest that
> > > > For compatiable, run
> > > > exec sp_dbcmptlevel 'database_name', '90';
> > > > (It is OK for me to exec. it)
> > > >
> > > > For alter authorization, run
> > > > ALTER AUTHORIZATION ON DATABASE::databasename to new
> > > > which produced:
> > > > "Msg 15151, Level 16, State 1, Line 1
> > > > Cannot find the principal 'new', because it does not exist or you do not
> > > > have permission."
> > > >
> > > > I have trouble here. I do not know how to do it. Did I do something wrong?
> > > > What is the correct way/steps?
> > > > Are there any tricks in backup and restore process?
> > > >
> > > > Thank you for any help.
> > > >
> > > > David
> > > >
> > >
> > >
> > >|||Thank you, Player and Lucas:
It works now. Valid_login = "my machine\my login name" which is under sql
server\security\logins
David
"david" wrote:
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB. Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
backup (SQL2000)/restore (SQL2005) problem in details
Sorry, I have to give more detail about my question.
I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in database: machine_name\my_login_name. OS: 2000server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same name DB. Auto
generated the user list which is same as in original database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the node databases: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I can not either show the diagram or create a new diagram on this restored
database DB.
I do not know the detail steps for doing it. MSDN articles suggest that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
(It is OK for me to exec. it)
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to new
which produced:
"Msg 15151, Level 16, State 1, Line 1
Cannot find the principal 'new', because it does not exist or you do not
have permission."
I have trouble here. I do not know how to do it. Did I do something wrong?
What is the correct way/steps?
Are there any tricks in backup and restore process?
Thank you for any help.
DavidDid you copy the user accounts and logins from SQL Server 2000 to 2005?
"david" <david@.discussions.microsoft.com> wrote in message
news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some
> people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB.
> Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this
> database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog
> box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>|||NO, I did not copy user accounts and logins from SQL Server 2000.
When I made a backup with COMPLETE option, the backup carry all information
about the database. When I restored the database, all accounts and sttatus
for old machine automatically appear in the user list for the restored
database under SQL Server 2005 on new machine.
David
"bass_player [SBS-MVP]" wrote:
> Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> "david" <david@.discussions.microsoft.com> wrote in message
> news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
>
>|||Hi David
Could you go to Microsoft SQL Server Management Studio and see under the
Security section of the SQL Server itself (not the database), and see if you
have any of the users in that one correspond/mapped to the database user?
My guess is that if you are only backup and restore the user database, it
will not carry the login information which is stored in system database.
Have you tried to log on as an sa (if it is on mixed mode) and tried to do
the things that you wanted to do?
Lucas
"david" wrote:
[vbcol=seagreen]
> NO, I did not copy user accounts and logins from SQL Server 2000.
> When I made a backup with COMPLETE option, the backup carry all informatio
n
> about the database. When I restored the database, all accounts and sttatus
> for old machine automatically appear in the user list for the restored
> database under SQL Server 2005 on new machine.
> David
>
> "bass_player [SBS-MVP]" wrote:
>|||Thank you.
Could you tell me the correct way for backup the database in SQL Server 2000
?
Dabin
"Lucas Kartawidjaja" wrote:
[vbcol=seagreen]
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if y
ou
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
>|||Sorry, some mistake in my description.
All users under databases should be under security of SQL Server. Restate as
follows:
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in security of server: machine_name\my_login_name. OS: Win
2000 server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same database name
DB. It Automatically
generated the user list (under DB) which is same as under DB in original
database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the SQL SERVER: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
"Lucas Kartawidjaja" wrote:
[vbcol=seagreen]
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if y
ou
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
>|||Thank you, Player and Lucas:
It works now. Valid_login = "my machine\my login name" which is under sql
server\security\logins
David
"david" wrote:
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some peopl
e
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB. Aut
o
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this databas
e
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog bo
x
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
I have trouble with it. I have tried several ways and talked to some people
in the forum, but it is not working. The following is waht I did.
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in database: machine_name\my_login_name. OS: 2000server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same name DB. Auto
generated the user list which is same as in original database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the node databases: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
I can not either show the diagram or create a new diagram on this restored
database DB.
I do not know the detail steps for doing it. MSDN articles suggest that
For compatiable, run
exec sp_dbcmptlevel 'database_name', '90';
(It is OK for me to exec. it)
For alter authorization, run
ALTER AUTHORIZATION ON DATABASE::databasename to new
which produced:
"Msg 15151, Level 16, State 1, Line 1
Cannot find the principal 'new', because it does not exist or you do not
have permission."
I have trouble here. I do not know how to do it. Did I do something wrong?
What is the correct way/steps?
Are there any tricks in backup and restore process?
Thank you for any help.
DavidDid you copy the user accounts and logins from SQL Server 2000 to 2005?
"david" <david@.discussions.microsoft.com> wrote in message
news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some
> people
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB.
> Auto
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this
> database
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog
> box
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>|||NO, I did not copy user accounts and logins from SQL Server 2000.
When I made a backup with COMPLETE option, the backup carry all information
about the database. When I restored the database, all accounts and sttatus
for old machine automatically appear in the user list for the restored
database under SQL Server 2005 on new machine.
David
"bass_player [SBS-MVP]" wrote:
> Did you copy the user accounts and logins from SQL Server 2000 to 2005?
> "david" <david@.discussions.microsoft.com> wrote in message
> news:E45E94E2-C4CF-4488-BF6D-D048A4C6F175@.microsoft.com...
>
>|||Hi David
Could you go to Microsoft SQL Server Management Studio and see under the
Security section of the SQL Server itself (not the database), and see if you
have any of the users in that one correspond/mapped to the database user?
My guess is that if you are only backup and restore the user database, it
will not carry the login information which is stored in system database.
Have you tried to log on as an sa (if it is on mixed mode) and tried to do
the things that you wanted to do?
Lucas
"david" wrote:
[vbcol=seagreen]
> NO, I did not copy user accounts and logins from SQL Server 2000.
> When I made a backup with COMPLETE option, the backup carry all informatio
n
> about the database. When I restored the database, all accounts and sttatus
> for old machine automatically appear in the user list for the restored
> database under SQL Server 2005 on new machine.
> David
>
> "bass_player [SBS-MVP]" wrote:
>|||Thank you.
Could you tell me the correct way for backup the database in SQL Server 2000
?
Dabin
"Lucas Kartawidjaja" wrote:
[vbcol=seagreen]
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if y
ou
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
>|||Sorry, some mistake in my description.
All users under databases should be under security of SQL Server. Restate as
follows:
(1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
COMPLETE backup setup, owners: dbo. Security:Windows mode
and my login name in security of server: machine_name\my_login_name. OS: Win
2000 server
(2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database with same database name
DB. It Automatically
generated the user list (under DB) which is same as under DB in original
database server: dbo
(owner), guest, ASPNET and so on. My login name in new server machine,
displayed in security under the SQL SERVER: nwe_machine_name\new
loginname (has a space between two words).
(5)Now I add new user to the stored database DB:
Expand Security under DB.
Rigth click on Users and select new user. Dialog pop up.
Broswer Login Name: nwe_machine_name\new loginname
Type in user name: new
Browser default schema: db_owner
Select Database Role Menbership: db_owner
Click OK.
User new is added in the list.
(6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
work. When I click the tree node Database Diagrams, I get
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
"Database diagram support objects cannot be installed because this database
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
"Lucas Kartawidjaja" wrote:
[vbcol=seagreen]
> Hi David
> Could you go to Microsoft SQL Server Management Studio and see under the
> Security section of the SQL Server itself (not the database), and see if y
ou
> have any of the users in that one correspond/mapped to the database user?
> My guess is that if you are only backup and restore the user database, it
> will not carry the login information which is stored in system database.
> Have you tried to log on as an sa (if it is on mixed mode) and tried to do
> the things that you wanted to do?
> Lucas
> "david" wrote:
>|||Thank you, Player and Lucas:
It works now. Valid_login = "my machine\my login name" which is under sql
server\security\logins
David
"david" wrote:
> Sorry, I have to give more detail about my question.
> I have trouble with it. I have tried several ways and talked to some peopl
e
> in the forum, but it is not working. The following is waht I did.
> (1) Backup, say DB.BAk from SQL Server 2000: use Enterprise Manager with
> COMPLETE backup setup, owners: dbo. Security:Windows mode
> and my login name in database: machine_name\my_login_name. OS: 2000server
> (2) Copy backup file to another machine with SQL Server 2005. OS: XP pro
> (3) Start SQL Server Management Studio of SQL Server 2005.
> (4) Use Restore to restore the backup to a database with same name DB. Aut
o
> generated the user list which is same as in original database server: dbo
> (owner), guest, ASPNET and so on. My login name in new server machine,
> displayed in security under the node databases: nwe_machine_name\new
> loginname (has a space between two words).
> (5)Now I add new user to the stored database DB:
> Expand Security under DB.
> Rigth click on Users and select new user. Dialog pop up.
> Broswer Login Name: nwe_machine_name\new loginname
> Type in user name: new
> Browser default schema: db_owner
> Select Database Role Menbership: db_owner
> Click OK.
> User new is added in the list.
>
> (6) Tables, Viewers, and SPs are OK. But Database Diagrams need to
> work. When I click the tree node Database Diagrams, I get
> the error massage. I can not either display the diagram or create new
> diagram on the database. The error message:
> "Database diagram support objects cannot be installed because this databas
e
> does not have valid owner.
> To continue, first use the Files page of the Database Properties dialog bo
x
> ot the Alter Authorization statement
> to set the database owner to a valid login, then add the datatbase diagram
> support objects."
> I can not either show the diagram or create a new diagram on this restored
> database DB.
> I do not know the detail steps for doing it. MSDN articles suggest that
> For compatiable, run
> exec sp_dbcmptlevel 'database_name', '90';
> (It is OK for me to exec. it)
> For alter authorization, run
> ALTER AUTHORIZATION ON DATABASE::databasename to new
> which produced:
> "Msg 15151, Level 16, State 1, Line 1
> Cannot find the principal 'new', because it does not exist or you do not
> have permission."
> I have trouble here. I do not know how to do it. Did I do something wrong?
> What is the correct way/steps?
> Are there any tricks in backup and restore process?
> Thank you for any help.
> David
>
Thursday, February 16, 2012
Backup - [WildPacket]
New on SQL. Running the BlackBerry DB on this SQL2000.
Within the SQL Enterprise Console I right click on the BESMgmt DB and then
click All tasks -> Backup DB -> in destination backup to it shows me the
location and a file named Backup4Aug04. I want to rename this file?
Second I see the 2 files with *.TRN and *.BAK which I know what these files
are.
The weird thing is along with these 2 files and Backup4Aug04 the date stamp
changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
am sure our DB is not that big.
I want to know what this Backup4Aug04 file is and what is it doing?
Advise please.
Thank you.WILDPACKET wrote:
> New on SQL. Running the BlackBerry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.|||WILDPACKET,
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
- .TRN transaction log backup
- .BAK database backup
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:
> New on SQL. Running the BlackBerry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
> WILDPACKET,
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> You can remove it or add a new one that will be the new destination (if
> selected).
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> - .TRN transaction log backup
> - .BAK database backup
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
> > New on SQL. Running the BlackBerry DB on this SQL2000.
> >
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> >
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> >
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> >
> > I want to know what this Backup4Aug04 file is and what is it doing?
> >
> > Advise please.
> >
> > Thank you.|||I am blowing away my SQL server because it is running on Win2000 server and I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
> WILDPACKET,
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> You can remove it or add a new one that will be the new destination (if
> selected).
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> - .TRN transaction log backup
> - .BAK database backup
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
> > New on SQL. Running the BlackBerry DB on this SQL2000.
> >
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> >
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> >
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> >
> > I want to know what this Backup4Aug04 file is and what is it doing?
> >
> > Advise please.
> >
> > Thank you.|||See if this helps.
How to move databases between computers that are running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"WILDPACKET" wrote:
> I am blowing away my SQL server because it is running on Win2000 server and I
> want to install Win2003 and then reinstall SQL 2000. Is there a free
> too/utility which can assist me in perfroming all the proper
> documentation/configuration?
> Thank you.
>
>
> "Alejandro Mesa" wrote:
> > WILDPACKET,
> >
> > > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > > click All tasks -> Backup DB -> in destination backup to it shows me the
> > > location and a file named Backup4Aug04. I want to rename this file?
> >
> > You can remove it or add a new one that will be the new destination (if
> > selected).
> >
> > > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > > are.
> >
> > - .TRN transaction log backup
> > - .BAK database backup
> >
> > > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > > am sure our DB is not that big.
> >
> > If you select "Append to media", then every backup will be added and the
> > previous stay intact. If you select "Overwrite existing media", then the
> > media will be overwritten with the new backup and no previous will be
> > available.
> >
> >
> > AMB
> >
> > "WILDPACKET" wrote:
> >
> > > New on SQL. Running the BlackBerry DB on this SQL2000.
> > >
> > > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > > click All tasks -> Backup DB -> in destination backup to it shows me the
> > > location and a file named Backup4Aug04. I want to rename this file?
> > >
> > > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > > are.
> > >
> > > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > > am sure our DB is not that big.
> > >
> > > I want to know what this Backup4Aug04 file is and what is it doing?
> > >
> > > Advise please.
> > >
> > > Thank you.
Within the SQL Enterprise Console I right click on the BESMgmt DB and then
click All tasks -> Backup DB -> in destination backup to it shows me the
location and a file named Backup4Aug04. I want to rename this file?
Second I see the 2 files with *.TRN and *.BAK which I know what these files
are.
The weird thing is along with these 2 files and Backup4Aug04 the date stamp
changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
am sure our DB is not that big.
I want to know what this Backup4Aug04 file is and what is it doing?
Advise please.
Thank you.WILDPACKET wrote:
> New on SQL. Running the BlackBerry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.|||WILDPACKET,
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
- .TRN transaction log backup
- .BAK database backup
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:
> New on SQL. Running the BlackBerry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
> WILDPACKET,
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> You can remove it or add a new one that will be the new destination (if
> selected).
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> - .TRN transaction log backup
> - .BAK database backup
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
> > New on SQL. Running the BlackBerry DB on this SQL2000.
> >
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> >
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> >
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> >
> > I want to know what this Backup4Aug04 file is and what is it doing?
> >
> > Advise please.
> >
> > Thank you.|||I am blowing away my SQL server because it is running on Win2000 server and I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
> WILDPACKET,
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> You can remove it or add a new one that will be the new destination (if
> selected).
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> - .TRN transaction log backup
> - .BAK database backup
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
> > New on SQL. Running the BlackBerry DB on this SQL2000.
> >
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> >
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> >
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> >
> > I want to know what this Backup4Aug04 file is and what is it doing?
> >
> > Advise please.
> >
> > Thank you.|||See if this helps.
How to move databases between computers that are running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"WILDPACKET" wrote:
> I am blowing away my SQL server because it is running on Win2000 server and I
> want to install Win2003 and then reinstall SQL 2000. Is there a free
> too/utility which can assist me in perfroming all the proper
> documentation/configuration?
> Thank you.
>
>
> "Alejandro Mesa" wrote:
> > WILDPACKET,
> >
> > > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > > click All tasks -> Backup DB -> in destination backup to it shows me the
> > > location and a file named Backup4Aug04. I want to rename this file?
> >
> > You can remove it or add a new one that will be the new destination (if
> > selected).
> >
> > > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > > are.
> >
> > - .TRN transaction log backup
> > - .BAK database backup
> >
> > > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > > am sure our DB is not that big.
> >
> > If you select "Append to media", then every backup will be added and the
> > previous stay intact. If you select "Overwrite existing media", then the
> > media will be overwritten with the new backup and no previous will be
> > available.
> >
> >
> > AMB
> >
> > "WILDPACKET" wrote:
> >
> > > New on SQL. Running the BlackBerry DB on this SQL2000.
> > >
> > > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > > click All tasks -> Backup DB -> in destination backup to it shows me the
> > > location and a file named Backup4Aug04. I want to rename this file?
> > >
> > > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > > are.
> > >
> > > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > > am sure our DB is not that big.
> > >
> > > I want to know what this Backup4Aug04 file is and what is it doing?
> > >
> > > Advise please.
> > >
> > > Thank you.
Backup - [WildPacket]
WILDPACKET wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.WILDPACKET,
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
- .TRN transaction log backup
- .BAK database backup
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||I am blowing away my SQL server because it is running on Win2000 server and
I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||See if this helps.
How to move databases between computers that are running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
AMB
"WILDPACKET" wrote:
[vbcol=seagreen]
> I am blowing away my SQL server because it is running on Win2000 server an
d I
> want to install Win2003 and then reinstall SQL 2000. Is there a free
> too/utility which can assist me in perfroming all the proper
> documentation/configuration?
> Thank you.
>
>
> "Alejandro Mesa" wrote:
>|||New on SQL. Running the blackberry DB on this SQL2000.
Within the SQL Enterprise Console I right click on the BESMgmt DB and then
click All tasks -> Backup DB -> in destination backup to it shows me the
location and a file named Backup4Aug04. I want to rename this file?
Second I see the 2 files with *.TRN and *.BAK which I know what these files
are.
The weird thing is along with these 2 files and Backup4Aug04 the date stamp
changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
am sure our DB is not that big.
I want to know what this Backup4Aug04 file is and what is it doing?
Advise please.
Thank you.|||WILDPACKET wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.|||WILDPACKET,
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
- .TRN transaction log backup
- .BAK database backup
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||I am blowing away my SQL server because it is running on Win2000 server and
I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.WILDPACKET,
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
- .TRN transaction log backup
- .BAK database backup
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||I am blowing away my SQL server because it is running on Win2000 server and
I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||See if this helps.
How to move databases between computers that are running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
AMB
"WILDPACKET" wrote:
[vbcol=seagreen]
> I am blowing away my SQL server because it is running on Win2000 server an
d I
> want to install Win2003 and then reinstall SQL 2000. Is there a free
> too/utility which can assist me in perfroming all the proper
> documentation/configuration?
> Thank you.
>
>
> "Alejandro Mesa" wrote:
>|||New on SQL. Running the blackberry DB on this SQL2000.
Within the SQL Enterprise Console I right click on the BESMgmt DB and then
click All tasks -> Backup DB -> in destination backup to it shows me the
location and a file named Backup4Aug04. I want to rename this file?
Second I see the 2 files with *.TRN and *.BAK which I know what these files
are.
The weird thing is along with these 2 files and Backup4Aug04 the date stamp
changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
am sure our DB is not that big.
I want to know what this Backup4Aug04 file is and what is it doing?
Advise please.
Thank you.|||WILDPACKET wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.|||WILDPACKET,
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
- .TRN transaction log backup
- .BAK database backup
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||I am blowing away my SQL server because it is running on Win2000 server and
I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>
Friday, February 10, 2012
backing up to a share from an sql 2000 cluster
Hi there,
Does any know a way of backing up to a share from an sql
2000 active/active cluster. I have no problems doing this
for stand alone installtions of sql 2000, but just can't
seem to get it to work from a cluster.
any help appreciated
Shaun
This shouldn't be an issue. What exactly is the problem you are having?
Can't get it to work isn't much of a clue<g>.
Andrew J. Kelly SQL MVP
"Shaun Buckley" <anonymous@.discussions.microsoft.com> wrote in message
news:4baf01c4805a$1f9113f0$a501280a@.phx.gbl...
> Hi there,
> Does any know a way of backing up to a share from an sql
> 2000 active/active cluster. I have no problems doing this
> for stand alone installtions of sql 2000, but just can't
> seem to get it to work from a cluster.
> any help appreciated
> Shaun
|||http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Shaun Buckley" <anonymous@.discussions.microsoft.com> wrote in message
news:4baf01c4805a$1f9113f0$a501280a@.phx.gbl...
> Hi there,
> Does any know a way of backing up to a share from an sql
> 2000 active/active cluster. I have no problems doing this
> for stand alone installtions of sql 2000, but just can't
> seem to get it to work from a cluster.
> any help appreciated
> Shaun
Does any know a way of backing up to a share from an sql
2000 active/active cluster. I have no problems doing this
for stand alone installtions of sql 2000, but just can't
seem to get it to work from a cluster.
any help appreciated
Shaun
This shouldn't be an issue. What exactly is the problem you are having?
Can't get it to work isn't much of a clue<g>.
Andrew J. Kelly SQL MVP
"Shaun Buckley" <anonymous@.discussions.microsoft.com> wrote in message
news:4baf01c4805a$1f9113f0$a501280a@.phx.gbl...
> Hi there,
> Does any know a way of backing up to a share from an sql
> 2000 active/active cluster. I have no problems doing this
> for stand alone installtions of sql 2000, but just can't
> seem to get it to work from a cluster.
> any help appreciated
> Shaun
|||http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Shaun Buckley" <anonymous@.discussions.microsoft.com> wrote in message
news:4baf01c4805a$1f9113f0$a501280a@.phx.gbl...
> Hi there,
> Does any know a way of backing up to a share from an sql
> 2000 active/active cluster. I have no problems doing this
> for stand alone installtions of sql 2000, but just can't
> seem to get it to work from a cluster.
> any help appreciated
> Shaun
Subscribe to:
Posts (Atom)