Viewing 15 posts - 3,946 through 3,960 (of 6,401 total)
You need SysAdmin, explicit permissions to run CREATE DATABASE or the dbcreator fixed server roles assigned to the login trying to create the database in order for it to be...
August 16, 2012 at 5:09 am
Problem is that your appending to the same backup file which never gets purged.
Change the backup task to backup to a single file each time it runs, then you can...
August 16, 2012 at 3:08 am
Logon trigger logging to the event log.
Login auditing changed from "Both failed and successful logins" to "Failed Logins only" without restarting the SQL server.
August 16, 2012 at 2:57 am
Please provide screen shots of the maintenance plan and the maintenance plan tasks.
August 16, 2012 at 2:55 am
Is SR_NO used as a foreign key to any other tables? Either through physical foreign keys or via application inserting into table and getting the SR_NO at insertion time?
What would...
August 16, 2012 at 2:52 am
Are you appending to the same file in the maintenance plan, or are you creating a new file on each run of the plan?
August 16, 2012 at 2:39 am
Hopefully this will do it based on the max record date for a particular day then linking back to itself to get that row for that particular database.
SELECT
T1.RECORD_DATE,
T1.DATABASE_NAME,
T1.FILE_SIZE,
T1.FILE_SIZE_USED,
T1.DATA_SIZE,
T1.DATA_SIZE_USED,
T1.LOG_SIZE,
T1.LOG_SIZE_USED
FROM
sometable T1
INNER JOIN
(
SELECT
MAX(RECORD_DATE)...
August 16, 2012 at 2:35 am
You would want the MAX recorded date, then you will need to group by the remaining columns
SELECT
MAX(RECORD_DATE)
DATABASE_NAME,
FILE_SIZE,
FILE_SIZE_USED,
DATA_SIZE,
DATA_SIZE_USED,
LOG_SIZE,
LOG_SIZE_USED
FROM
sometable
GROUP BY
DATABASE_NAME,
FILE_SIZE,
FILE_SIZE_USED,
DATA_SIZE,
DATA_SIZE_USED,
LOG_SIZE,
LOG_SIZE_USED
That will only give the last recorded value, not on a daily basis.
Will...
August 16, 2012 at 2:23 am
Looks like you might want SSIS for this.
Plenty on the topic in the stairways section.
Use it to load the file into the table, then you can use T-SQL to modify...
August 16, 2012 at 2:21 am
If the database is important, why wasn't the database stored on a server and not a desktop and why didnt you have a proper backup routine in place for the...
August 16, 2012 at 2:04 am
Good blog Wayne will bookmark that.
Just one thing you have a [/u] IFCode in the URL link, so if you click it you get a 404 error.
August 16, 2012 at 1:38 am
Trace the UOW back to the originiating host via sys.dm_exec_requests and terminate the DTC transaction from the source, that should resolve the issue.
August 15, 2012 at 8:20 am
The user you have specified in the data source doesnt have access to the SQL server or database in the datasource.
If you have used a SQL login, ensure the users...
August 15, 2012 at 7:10 am
The only posibility then that I am aware of is that the account your loging in as isn't sysadmin or a member of the SQL Agent fixed roles.
August 15, 2012 at 7:05 am
If your system was corrupted when you took the backup then it is likely that the backup is also corrupted hence why you are getting these errors.
The only way to...
August 15, 2012 at 3:52 am
Viewing 15 posts - 3,946 through 3,960 (of 6,401 total)