Database Unit Testing: sp3a

Showing posts with label sp3a. Show all posts

Sunday, March 11, 2012

Database restore.

Hi everyone,
We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy
database.
When Restoring I have trouble,because while I am killing current user
connections new connections are established and I cannot restore because the
database is in use.
What are my options to get round this issue ?
I connect remotely to the Server to restore.
Regards,Set the database to single user with the rollback option. See ALTER DATABASE in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
news:%23NKvABt4GHA.1012@.TK2MSFTNGP05.phx.gbl...
> Hi everyone,
> We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy database.
> When Restoring I have trouble,because while I am killing current user connections new connections
> are established and I cannot restore because the database is in use.
> What are my options to get round this issue ?
> I connect remotely to the Server to restore.
> Regards,
>|||Thanks.
I suppose it does not make any difference if done with ALTER DATABASE or
from Enterpise Manager - Options - Restrict Access - Single User.
Regards,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23Dfd4Gt4GHA.4616@.TK2MSFTNGP05.phx.gbl...
> Set the database to single user with the rollback option. See ALTER
> DATABASE in Books Online.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
> news:%23NKvABt4GHA.1012@.TK2MSFTNGP05.phx.gbl...
>> Hi everyone,
>> We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy
>> database.
>> When Restoring I have trouble,because while I am killing current user
>> connections new connections are established and I cannot restore because
>> the database is in use.
>> What are my options to get round this issue ?
>> I connect remotely to the Server to restore.
>> Regards,
>|||EM doesn't have a rollback option. If users are connected, then the EM operation will fail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
news:OqU%23JXt4GHA.4888@.TK2MSFTNGP03.phx.gbl...
> Thanks.
> I suppose it does not make any difference if done with ALTER DATABASE or from Enterpise Manager -
> Options - Restrict Access - Single User.
> Regards,
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23Dfd4Gt4GHA.4616@.TK2MSFTNGP05.phx.gbl...
>> Set the database to single user with the rollback option. See ALTER DATABASE in Books Online.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
>> news:%23NKvABt4GHA.1012@.TK2MSFTNGP05.phx.gbl...
>> Hi everyone,
>> We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy database.
>> When Restoring I have trouble,because while I am killing current user connections new
>> connections are established and I cannot restore because the database is in use.
>> What are my options to get round this issue ?
>> I connect remotely to the Server to restore.
>> Regards,
>>
>

Database restore.

Thursday, March 8, 2012

Database Restore Security Issue

We are doing a restore of a SQL database to a stand alone test server. We
were able to restore the database successfully to SQL Server 2000 sp3a. We
restored the data into a database that has the same name as the production
database. We installed the application that will be accessing the database
also without issue.
The problem we are running into is with the security. When the application
tries to access the data it says the user does not have permission. It
appears that the restore pulled in the security data from the production
server and when I try to add a new user (from the test server) under security
and give them access to the database I get an error saying "Errir 15401:
Windows NT useror roup 'Test\Administrator' not found. Check the name
again." Even if I go into the database itsel and go to users and try to add
one there. Same error message. How do I allow users from the test
environment to access the database?
Thanks for your help.
You need to link the existing user in the restored database to the login on
the server. Look up sp_change_users_login in BOL for details.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ken Ostrowski" <KenOstrowski@.discussions.microsoft.com> wrote in message
news:BDBC45C6-1186-4D41-8057-9EAC21C42DE7@.microsoft.com...
> We are doing a restore of a SQL database to a stand alone test server. We
> were able to restore the database successfully to SQL Server 2000 sp3a.
> We
> restored the data into a database that has the same name as the production
> database. We installed the application that will be accessing the
> database
> also without issue.
> The problem we are running into is with the security. When the
> application
> tries to access the data it says the user does not have permission. It
> appears that the restore pulled in the security data from the production
> server and when I try to add a new user (from the test server) under
> security
> and give them access to the database I get an error saying "Errir 15401:
> Windows NT useror roup 'Test\Administrator' not found. Check the name
> again." Even if I go into the database itsel and go to users and try to
> add
> one there. Same error message. How do I allow users from the test
> environment to access the database?
> Thanks for your help.

Database Restore Security Issue

We are doing a restore of a SQL database to a stand alone test server. We
were able to restore the database successfully to SQL Server 2000 sp3a. We
restored the data into a database that has the same name as the production
database. We installed the application that will be accessing the database
also without issue.
The problem we are running into is with the security. When the application
tries to access the data it says the user does not have permission. It
appears that the restore pulled in the security data from the production
server and when I try to add a new user (from the test server) under securit
y
and give them access to the database I get an error saying "Errir 15401:
Windows NT useror roup 'Test\Administrator' not found. Check the name
again." Even if I go into the database itsel and go to users and try to add
one there. Same error message. How do I allow users from the test
environment to access the database?
Thanks for your help.You need to link the existing user in the restored database to the login on
the server. Look up sp_change_users_login in BOL for details.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ken Ostrowski" <KenOstrowski@.discussions.microsoft.com> wrote in message
news:BDBC45C6-1186-4D41-8057-9EAC21C42DE7@.microsoft.com...
> We are doing a restore of a SQL database to a stand alone test server. We
> were able to restore the database successfully to SQL Server 2000 sp3a.
> We
> restored the data into a database that has the same name as the production
> database. We installed the application that will be accessing the
> database
> also without issue.
> The problem we are running into is with the security. When the
> application
> tries to access the data it says the user does not have permission. It
> appears that the restore pulled in the security data from the production
> server and when I try to add a new user (from the test server) under
> security
> and give them access to the database I get an error saying "Errir 15401:
> Windows NT useror roup 'Test\Administrator' not found. Check the name
> again." Even if I go into the database itsel and go to users and try to
> add
> one there. Same error message. How do I allow users from the test
> environment to access the database?
> Thanks for your help.

Database Restore Security Issue

We are doing a restore of a SQL database to a stand alone test server. We
were able to restore the database successfully to SQL Server 2000 sp3a. We
restored the data into a database that has the same name as the production
database. We installed the application that will be accessing the database
also without issue.
The problem we are running into is with the security. When the application
tries to access the data it says the user does not have permission. It
appears that the restore pulled in the security data from the production
server and when I try to add a new user (from the test server) under security
and give them access to the database I get an error saying "Errir 15401:
Windows NT useror roup 'Test\Administrator' not found. Check the name
again." Even if I go into the database itsel and go to users and try to add
one there. Same error message. How do I allow users from the test
environment to access the database?
Thanks for your help.You need to link the existing user in the restored database to the login on
the server. Look up sp_change_users_login in BOL for details.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ken Ostrowski" <KenOstrowski@.discussions.microsoft.com> wrote in message
news:BDBC45C6-1186-4D41-8057-9EAC21C42DE7@.microsoft.com...
> We are doing a restore of a SQL database to a stand alone test server. We
> were able to restore the database successfully to SQL Server 2000 sp3a.
> We
> restored the data into a database that has the same name as the production
> database. We installed the application that will be accessing the
> database
> also without issue.
> The problem we are running into is with the security. When the
> application
> tries to access the data it says the user does not have permission. It
> appears that the restore pulled in the security data from the production
> server and when I try to add a new user (from the test server) under
> security
> and give them access to the database I get an error saying "Errir 15401:
> Windows NT useror roup 'Test\Administrator' not found. Check the name
> again." Even if I go into the database itsel and go to users and try to
> add
> one there. Same error message. How do I allow users from the test
> environment to access the database?
> Thanks for your help.

Wednesday, March 7, 2012

Database reporting time differently than system

Hiya,

I have a database on a SQL Server 2000 (sp3a) installation. For some reason it's reporting time that is 7 hours ahead of the system time.

The application is on one server the DB is on a shared production server. The app server and the DB server are reporting the same system time and are using a network time server. All the other db's on the shared production db server are reporting time correctly.

My questions:

Is there a T-SQL query to use to see what the time/timezone is for that database?
Is there a T-SQL query I can use to set the db time (not the system time)?
Anyone have any other suggestions as to what could be wrong?

Thanks in advance for any help!
'cheleIs this from a select getdate() query in QA or the output of some app or stored proc? If app or stored proc, check for date manipulation. SQL Server picks up its time from the serer clock, there is no separate SQL Server clock.

Unless it is using the getutcdate(), which is also derived from the system date / time / time zone setting.

<QUOTE>
GETUTCDATE

Returns the datetime value representing the current UTC time (Universal Time Coordinate or Greenwich Mean Time). The current UTC time is derived from the current local time and the time zone setting in the operating system of the computer on which SQL Server is running.

Syntax

GETUTCDATE()

</QUOTE>|||Thanks for the help.

It's a canned app. Epolicy by McAfee, to be precise. I guess I will go to them for tech support now that I know it's probably not something I did.

Tuesday, February 14, 2012

Database Overwritten

We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
database and all went well. However, this database has been overwritten
somehow. We definitely have not restored any further files from tape.
The "Date Modified" has been changed on the DB and LOG files. At this time
the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
process ID 3740", followed by "Starting up database 'MYDATABASE'", then
"Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 more
seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
"Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.."
We have no Database Maintenance Plans in place. Our backups our taken by
CommVault Galaxy and this shows no restores. I need to find out what has
happened. Can anybody help?My guess, from the messages, is that someone ran sp_detach_db and then sp_attach_db. But, AFAIK,
there's no more logged that what you have now...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gerrry" <Gerrry@.discussions.microsoft.com> wrote in message
news:464F2B26-54FC-4C36-8F71-E2450B0B6559@.microsoft.com...
> We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
> database and all went well. However, this database has been overwritten
> somehow. We definitely have not restored any further files from tape.
> The "Date Modified" has been changed on the DB and LOG files. At this time
> the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
> process ID 3740", followed by "Starting up database 'MYDATABASE'", then
> "Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 more
> seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
> "Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.."
> We have no Database Maintenance Plans in place. Our backups our taken by
> CommVault Galaxy and this shows no restores. I need to find out what has
> happened. Can anybody help?

Database Overwritten

We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
database and all went well. However, this database has been overwritten
somehow. We definitely have not restored any further files from tape.
The "Date Modified" has been changed on the DB and LOG files. At this time
the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
process ID 3740", followed by "Starting up database 'MYDATABASE'", then
"Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 more
seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
"Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.."
We have no Database Maintenance Plans in place. Our backups our taken by
CommVault Galaxy and this shows no restores. I need to find out what has
happened. Can anybody help?
My guess, from the messages, is that someone ran sp_detach_db and then sp_attach_db. But, AFAIK,
there's no more logged that what you have now...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gerrry" <Gerrry@.discussions.microsoft.com> wrote in message
news:464F2B26-54FC-4C36-8F71-E2450B0B6559@.microsoft.com...
> We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
> database and all went well. However, this database has been overwritten
> somehow. We definitely have not restored any further files from tape.
> The "Date Modified" has been changed on the DB and LOG files. At this time
> the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
> process ID 3740", followed by "Starting up database 'MYDATABASE'", then
> "Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 more
> seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
> "Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.."
> We have no Database Maintenance Plans in place. Our backups our taken by
> CommVault Galaxy and this shows no restores. I need to find out what has
> happened. Can anybody help?

Database Overwritten

We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
database and all went well. However, this database has been overwritten
somehow. We definitely have not restored any further files from tape.
The "Date Modified" has been changed on the DB and LOG files. At this time
the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
process ID 3740", followed by "Starting up database 'MYDATABASE'", then
"Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 mor
e
seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
"Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.."
We have no Database Maintenance Plans in place. Our backups our taken by
CommVault Galaxy and this shows no restores. I need to find out what has
happened. Can anybody help?My guess, from the messages, is that someone ran sp_detach_db and then sp_a
ttach_db. But, AFAIK,
there's no more logged that what you have now...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gerrry" <Gerrry@.discussions.microsoft.com> wrote in message
news:464F2B26-54FC-4C36-8F71-E2450B0B6559@.microsoft.com...
> We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
> database and all went well. However, this database has been overwritten
> somehow. We definitely have not restored any further files from tape.
> The "Date Modified" has been changed on the DB and LOG files. At this time
> the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
> process ID 3740", followed by "Starting up database 'MYDATABASE'", then
> "Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 m
ore
> seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
> "Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.."
> We have no Database Maintenance Plans in place. Our backups our taken by
> CommVault Galaxy and this shows no restores. I need to find out what has
> happened. Can anybody help?

Sunday, March 11, 2012

Database restore.

Database restore.

Database restore.

Thursday, March 8, 2012

Database Restore Security Issue

Database Restore Security Issue

Database Restore Security Issue

Wednesday, March 7, 2012

Database reporting time differently than system

Tuesday, February 14, 2012

Database Overwritten

Database Overwritten

Database Overwritten

Database Unit Testing

Blog Archive

About Me