Viewing 15 posts - 46 through 60 (of 2,893 total)
"...The location of the transaction logs is on the server itself as is the transaction backup logs. The main backup is off the sever on an accessible fileshare (due to...
November 15, 2022 at 5:30 pm
"...Our database server is recording it's transactional backup logs from 6am to 8pm (every hour-on-the-hour), 6 days a week. The old logs are removed after 7 days. The big weekly...
November 15, 2022 at 5:16 pm
1 week of backups isn't very long. Sometimes problems are discovered after a few weeks and it's helpful to restore the database to a different server temporarily to look at...
November 15, 2022 at 5:11 pm
I think we used to exclude from virus scans based on extension, not an entire folder because other files may be worth scanning if something sneaks in there. Exclude .MDF,...
November 11, 2022 at 2:04 pm
Did the transaction log suddenly grow very large ?
November 10, 2022 at 5:35 pm
You could add a step to update your file before the BCP.
or
In your select, you could use a CASE statement to replace NULL with 0
SELECT
CASE WHEN...
November 9, 2022 at 4:36 pm
Can you make a linked server to MYSQL ? Then use that to push data ?
November 4, 2022 at 3:13 pm
October 21, 2022 at 5:44 pm
And if you want to search all databases at the same time:
exec sp_MSforeachdb 'use [?] select ''?'' as dbName, name as ''SP_Name'', obj.type,
substring(definition,CHARINDEX(''##'', definition)-45,150) as ''Code_Snippet''...
October 21, 2022 at 4:41 pm
Reminds me of a game called "Bullshit Bingo".
Make a bingo card, with each box containing trendy buzzwords. Check them off until you win, then yell "BINGO" !
October 17, 2022 at 7:07 pm
DUPLICATE THREAD. Other thread here:
https://www.sqlservercentral.com/forums/topic/uninitialized-subscription-2
Are you using multiple accounts also ?
October 11, 2022 at 2:52 pm
Without the time portion, or an auto incrementing identity field, how is it possible to know which is the most recent ?
Start capturing the time portion ??
September 22, 2022 at 4:22 pm
I know this is an old topic but we are using Cohesity 6.6. It now has SQL log backup and Point in time restores. So far I'm liking it...
September 22, 2022 at 1:49 pm
1 file is getting bigger and/or new files are getting created ??
Maybe a job is copying files from the original trace location to the new location ?
September 20, 2022 at 8:54 pm
Would some of these free tools be a starting point for someone unfamiliar troubleshooting ?
https://www.idera.com/productssolutions/freetools/
Other companies may have similar tools, and most will also offer free trials of paid...
September 20, 2022 at 8:42 pm
Viewing 15 posts - 46 through 60 (of 2,893 total)