Viewing 15 posts - 46 through 60 (of 2,897 total)
Sounds similar to what I did a while back. It was several years ago, so not fresh in my memory.
November 28, 2022 at 3:09 pm
You may not need the T-Logs in DEV, but they can be very important in PROD. So the place to start is where the databases originate and see if your...
November 28, 2022 at 2:53 pm
You can prepare the restore with the settings and options with SSMS, but instead of running it, "Script to query window" and compare your T-SQL script with the SSMS generated...
November 21, 2022 at 8:58 pm
"...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
Viewing 15 posts - 46 through 60 (of 2,897 total)