DB Engine :: Last Accessed Database Date
Jul 22, 2015how to check the last accessed date of the list of all databases in a particular server in MS SQL SERVER.
View 12 Replies
ADVERTISEMENT
DB Engine :: Restore Database When It Is Accessed By Application?
Oct 5, 2015Our application team make design changes of the database in their development server and asks me to restore the bak file from the development server into the production server with replace command. The database in the production server is connected to the application server and so when I try to restore the database error message comes that the database is in use.
So first I find out the sessions with the logins who is the user in the database with sys.dm_exec_sessions joined with sys.dm_exec_requests and then kill the sessions. And after that it is possible to restore. But many times when I kill the session and try to restore in between new sessions comes into effect which are generated from the web server and many times I have to resubmit the query in the dmv's and find the sessions and kill it again and again before restore can be done. Is there any correct method to restore an active database which is being accessed by the application from a web server with out stopping the web server?
DB Engine :: Check Last Database Index Reorg Date And Time?
May 4, 2015Are there anyway I can check my last database reorg date and time using Tsql ?
View 5 Replies View RelatedSQL Server Admin 2014 :: List All Databases In Instance That Are Not Accessed Before Given Date
Jan 10, 2015Looking for query that lists all databases, in an instance, that are not accessed before a given date (e.g., not accessed before December 31, 2014)?
View 6 Replies View RelatedIs There Anyway To Tell When A Database Was Last Accessed Or Changed?
May 29, 2007Is there a simple way to tell when a database was last accessed or changed?
We have some databases on old servers which we would like to discontinue but do not know if they are being used.
We would rather not just take them offline.
Is there anyway I can find out if they are still being used?
Please help if you can.
Regards, Major (that is my Christian name ;-)
How Do I Find When My Database Was Last Accessed
Dec 11, 2007
I have a bunch of datbases I have created during the development process. I want to delete those no longer being used. How do I find when the last time a database was accessed?
Thanks.
Need Help To Check When Was Database Last Accessed/updated
Jul 29, 2004I am trying to manage a sql server.
In this sql server, I have about 200 databases.
Is there any way/suggestions to check to see if some of the database has not been accessed/updated for the last month or longer?
I am trying to develop a system to remove the database that's no longer needed.
Thank you.
SQL Server 2008 :: Database Can't Be Accessed
Apr 9, 2015I was having issue with one of my databases in SQL EXPRESS. It is offline this morning …it said “Database 'MyDB' cannot be opened due to inaccessible files or insufficient memory or disk space. When I checked the error log ..it only said “FCB::Open failed: Could not open file D:DatabasesMyDB_Data.mdf for file number 1. OS error: 32(failed to retrieve text for this error. Reason: 15100).
I did alter database offline and and online ..it works for me( I can access the database again but I need to find the cause of this issue )I checked the max memory setting is still by default .. not limited for SQL ..it could be the cause ?
Script To Log/record The Users Who Accessed My Database
Jul 10, 2006Hi,
I am hosting my database on a third-party Microsoft SQL server. The guest user is "Off". But, I am not sure if any one else is accessing/viewing/editing my database contents.
Can I know/log/record the users/logins who are viewing/accessing my database. Is there any script or any exisitng machnism which can be used to track these users.
Also, are there any things that I should take care with my database from outside users.
Thanks
-Sudhakar
Script To Log/record The Users Who Accessed My Database
Jul 10, 2006Hi,
I am hosting my database on a third-party Microsoft SQL server. The guest user is "Off". But, I am not sure if any one else is accessing/viewing/editing my database contents.
Can I know/log/record the users/logins who are viewing/accessing my database. Is there any script or any exisitng machnism which can be used to track these users.
Also, are there any things that I should take care with my database from outside users.
Thanks
-Sudhakar
Script To Log/record The Users Who Accessed My Database
Jul 10, 2006Hi,I am hosting my database on a third-party Microsoft SQL server. The guest user is "Off". But, I am not sure if any one else is accessing/viewing/editing my database contents. Can I know/log/record the users/logins who are viewing/accessing my database. Is there any script or any exisitng machnism which can be used to track these users.Also, are there any things that I should take care with my database from outside users.Thanks-Sudhakar
View 1 Replies View RelatedSQL Server 2008 :: How To Find If A Database Has Been Accessed / Used Since Last Month
Jul 6, 2015Is there anyway I can find or make a report if a databases has been accessed/used since last month?
View 4 Replies View RelatedSQL Tools :: When Was Database Last Accessed By Each User / Login In Server
Jul 6, 2015I have a plan of decommissioning of unused databases which are not been in use for quite some time. is there any simple way/t-sql to find out When was the database last accessed by each user/login in sqlserver.
View 2 Replies View RelatedData Reside In Memory And Accessed Via CLR Database Objects.
Nov 7, 2007Hi,
I want to manage memory relational data in the memory(Insert, delete, return) and manipulate the data via SQL 2005 and CLR database objects.
The gool is to manage a table that relatively has a lot of inserts and deletes which takes a lot of IO operations and i want to reduce it. the data itself is not permanant each row deleted from the table after 15-20 minutes.
I looked at the extended stored procedure and other CLR enable objects and it seams that they all return data from the database itself.
How can i return data that is reside in the memory?
Thanks.
DB Engine :: How To Generate Null Row Two Different Date In Data
Oct 8, 2015how to generate null row two different date in data in sql ,,for example as below
name age DOB
ram 20 04/05/1988
kumar 30 04/05/1988
NULL NULL NULL
jonh 25 05/06/1988
DB Engine :: Backup Encryption With Compression With Date Format
Jul 31, 2015Current am using the below script it is working fine i need use ENCRYPTION script where i should add this
NOREWIND, NOUNLOAD, COMPRESSION,
ENCRYPTION(ALGORITHM = AES_256,
SERVER CERTIFICATE = [BackupCertificate]), STATS = 10
USE [master]
GO
[code]...
DB Engine :: How To Capture Date And Time When DB Changed To Single User
Nov 29, 2015I have a requirement to track the sqlserver when any DB changed from multiuser to singleuser.
I want to capture the date and time when anyone change any db from multiuser to single user and save this information in one text or csv file.
How can we do this using powershell?
SQL 2012 :: Database Mirroring And NT Authority Account For Database Engine?
Dec 2, 2014I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domainuser. I inherited a production mirrored environment set up by someone else. On the production servers the database engine service account is NT Authorityuser a local account. I am trying to practice installing Windows updates within a mirrored environment and I not sure how to proceed when the service account is NT Authority user account. should I change the service account to a domainuser?
View 2 Replies View RelatedThe Microsoft Jet Database Engine Cannot Open MS-Access Database
Aug 18, 2007
I have MS-Access as data source for one of the reports. I can preview the report fine from BI studio however, it does not work when I deploy it on report server.
The error is :
An error has occurred during report processing.
Cannot create a connection to data source '<data source name>'.
The Microsoft Jet database engine cannot open the file '<UNC location of the MS-Access database>'. It is already opened exclusively by another user, or you need permission to view its data.
MS-Access database is located on a different server.
Any help to solve this? I understand it has something to do with permission both on server where reporting service is running as well as the server where MS-access database is located. Pls help.
How Can We Modify The Files Path For The Database In Database Engine?
May 14, 2007Hi, all experts here,
Thank you very much for your kind attention.
I am trying to modify the files path (primary file, log file) of databases, but it looks like I am not able to mofidy their files path directly from the database property dialogue? Would please any experts here give me some ideas on what else can I try to figure it out? Thanks a lot in advance and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
How To Tell If Accessed
Nov 30, 2004I just got assigned to be our companies sql server dba, there are about 80 databases on various servers. I am suspecting many are not even used. Is there a way for me to tell the last time they were accessed and by whom? And, more importantly, the last time any changes have been made in the database? Thanks in advance.
View 7 Replies View RelatedTable Last Accessed
Apr 16, 2008Can i find out when a table was last accessed?
The purpose of this is to create a list of tables that could potentially be deleted. I would then prefix them with a d and the auto delete them after x number of days? or move them to a deletions database?
Just trying to automate a bit of house keeping in the active databases.
Tables Accessed
Mar 12, 2007I want to know howmany tables were accessed in a database from time A to B. How do I get the list of tables accessed (excluding the 'SELECT's)?
View 3 Replies View RelatedDatabase Search Engine
Jul 9, 2004Hi folks,
Whts up........??? M back, after a long gap.
I have come across with a major issue. And u know wht th issue is.........???
It is about th DATABASE SEARCH TOOL. I have a database of around 30 tables. Now I wud like to have aa search engine on my .asp page. There will be a text box on th page and one submit button. After typing some text in th text area n submitting th page, my package sud check tht perticular text in all th COLUMNS of all th TABLES, n whrevr it gets a match (exactly same, or by speech recognition), it sud through th links on th next page.
Nw i wud like u guys to take this problem, at th earliest n come up with a up to th mark solution.
Thnkx
How Come I Don't See Database Engine Under MSSQLSERVER
May 21, 2007in Surface Area Configuration for Features.
What the problem is?
Thanks in advance.
Cannot Connect To Database Engine
Jan 7, 2012i installed sql server 2005 but cant connect to database engine. i write (computer name)sqlexpress but it failed. error is:
TITLE: Connect to Server
------------------------------
Cannot connect to rezasqlexpress.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
How Come I Don't See Database Engine Under MSSQLSE
May 21, 2007in Surface Area Configuration for Features.
What the problem is?
Thanks in advance.
Cannot Connect To Database Engine
Apr 30, 2008Hi,
I've just installed a brand new instance of SQL on a new server. It's for our Helpdesk/Inventory software. All I needed to install was the DB Components and the Tools (primarily for Management Studio). I did not install SQL as a default instance, but called it TRACKIT8 (software using this instance). I have subsequently installs SP2 before trying to connect to the DB.
I am unable to conect to the DB Engine via Management Studio. In the Server name: field, there is a blank space, so I try to browse for a server, but I get nothing. I try to manually type the name of the server (NIASSQL2, localhost etc) into the field, but I cannot connect to the engine at all. I can see the services for the Server and Server Agent have started in the SQL Server Configuration Manager and I am able to change certain field in the properties of the Server and Agent (change the path of the error logs).
Is there something I am supposed to configure before I try to connect via the Management Studio? I am looking to change the paths of the Data Files, as I don't want them on my C: partition. Plus I have other instances I want to create and install. Any help would be greatly appreciated.
Cheers.
Sp2 Failed For Database Engine
Mar 14, 2007SP2 failed for database engine.
Following is the error:
EventType : sqlsesetup P1 : do_sqlgroupmember P2 : 0x7348
P3 : do_sqlgroupmember P4 : 0x7348 P5 : sqlca_sqlsecurityca.cpp@1132
P6 : unknown P7 : sql9 P8 : hotfix@ P9 : x86 P10 : 3042
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29512
Error Description : MSP Error: 29512 SQL Server Setup was unable add user NT AUTHORITYSYSTEM to local group DCCIBERSQLServer2005SQLAgentUser$DCSQL01$MSSQLSERVER.
any help appreciated...
Deleting A Database Engine
Mar 14, 2008I have recently installed SQL server 2005 express edition along with Sql server management studio expressI have run the installation twice and during the installation I have created two instances of SQL server one named instance having Windows authentication and the other default instance having mixed mode authentication. Now I want to delete the named instance. Could anybody tellme I can delete the named instance?
View 3 Replies View RelatedI Cannot Connect To The Database Engine ...
May 4, 2007I can connect to Analysis Service and Integration Service but I can not connect to the Database Engine. I receive the following error message:
Cannot connect to homebase.
Additional Information:
An error has occurred whlie establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server doesn not allow remote connections. (provider: SQL Network Interfaces, error: 25 - COnnection string is not valid)(Microsoft SQL Server, Error:87)
(Click on OK to continue)
DB Engine :: No Database Encryption Key Is Set
Jul 15, 2015I'm a newbie to SQL and I inherited a 2008 R2 Sql server with about 20 different databases on it. I've noticed that more than half of the databases are encrypted and I was looking to encrypt the rest but for some reason I am unable to do so. I'm assuming I already have a master key created but when I go to Options of the DB and change Encryption Enabled from False to True I get and error, "Cannot change database encryption state because no database encryption key is set." How I could use my existing key to encrypt the databases or would I have to create a separate key for each db?
View 6 Replies View RelatedUpgrading Database Engine To 64 Bit
May 7, 2008If I am upgrading the SQL Server 2005 32 bit to 64 bit (only DB Server), Do Applications that communicate with Database need to be upgraded to 64 bit as well???
Thanks,