Viewing 15 posts - 91 through 105 (of 153 total)
terry.home (5/17/2013)
Sorry I cannot really answer that.... as the server had been neglected, the backups appear to have failed for some time now.
Might not be a bad idea to setup...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 20, 2013 at 3:00 pm
I'm curious has your database full backups taken longer to backup after removing/deleting all that data? We deleted Terabytes of data (though we have less data our backups take...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 17, 2013 at 11:02 am
What is the minimum I need? Can I install a few DLLs and point it to a copy of an .mdf file with the connection string?
You would need to install...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 13, 2013 at 12:56 pm
(edit: since I have no image - the msg I receive is "An object (User) with the following name cannot be found. "Scott" (which is my Windows login). Check the...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 13, 2013 at 2:50 am
TecNQ (5/8/2013)
However, this does not answer my question exactly.
What I am after is a way to say to the database, ".. at 6pm tonight I want...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 9, 2013 at 2:07 am
SQL Show (5/8/2013)
I am about to blame the number of VLF files in your database. Your Purge might be adding lots of...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 8, 2013 at 9:50 pm
You can also test the if the bottleneck is coming from the backup disk or your data disk.
Backup to nul to test backup read speed, if it doesn't change (or...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 8, 2013 at 9:29 pm
dmcquilken (5/8/2013)
andriancruz (5/31/2010)
I'm using CmdExec to call VB Application to extract records. The application is running fine. But when I put into Jobs the status is always executing. Anyone...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 8, 2013 at 2:44 pm
My question:
Is it possible to schedule a nightly process to disconnect all live connections to a database? I am asking this because sometime we need to detach databases for maintenance...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 8, 2013 at 12:56 am
databoy (5/7/2013)
i have uninstalled the named instance...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 8, 2013 at 12:32 am
Sqlism (5/7/2013)
My requiremenet is all the users should be able...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 7, 2013 at 6:18 pm
Thanks for mentioning
When you delete a large or very large numberr of rows at one time, SQL Server defers the actual deletes. The next time a page with deleted r0w(s)...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 7, 2013 at 6:10 pm
Thanks Steve for reply!
The full backup isn't backing up the log, unless the index rebuild is running while the full backup is running. Then it will catch items changed...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 7, 2013 at 2:22 pm
1. If the transaction log is not backed up after the index rebuild or purge and before the the log shrink,
the shrink will likely fail, because there will be more...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 6, 2013 at 6:48 pm
I would imagine backup process "really" depends on your organization's requirements.
Backup the database with "Checksum" (Just to be safe using checksum)
Then using a Restore Verify Only
and using...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 6, 2013 at 6:13 pm
Viewing 15 posts - 91 through 105 (of 153 total)