No announcements
Found 2909936 threads
-
0 VotesScript to create a script to move all transaction logs
For tempdb, this is the model information (how tempdb is created at startup), not the current info.Answered | 5 Replies | 504 Views | Created by goswell - Tuesday, June 13, 2017 9:35 PM | Last reply by TiborK - Wednesday, June 14, 2017 12:39 PM
-
2 Votes
Logging Transact-SQL scripts
Mark, To capture this you can try setting up server audit which will capture all the activity against the server.Answered | 3 Replies | 1240 Views | Created by creativemindware - Friday, June 6, 2014 11:40 AM | Last reply by Ernest Ostrander - Saturday, June 7, 2014 3:06 AM -
1 Votes
Script to Shrink the Transaction Log File
The above script creates a cursor and walks through all databases.Answered | 5 Replies | 2676 Views | Created by Victor3357 - Thursday, February 25, 2016 11:53 PM | Last reply by Victor3357 - Friday, February 26, 2016 3:33 PM -
2 Votes
Move transaction logs with Power Shell?
Use Powershell to fire a SQL Command that would alter the database to move the files.Answered | 3 Replies | 11039 Views | Created by JackOfAllTradesMasterAtNone - Friday, May 13, 2011 10:24 PM | Last reply by G.Wilson - Monday, May 16, 2011 1:48 AM -
1 Votes
SQL Script for total daily transaction?
Hi, I simply loop through my log backups and count the number of transactions.Answered | 4 Replies | 4032 Views | Created by Manthan(Monty) - Tuesday, February 2, 2016 6:39 PM | Last reply by Pelso - Friday, July 13, 2018 10:04 AM -
0 Votes
Script to skip failed transaction of article
Hi RajeshSql, We can skip errors in Transactional Replication using the Distribution Agent -SkipErrors parameter or by using the Distribution Agent profile ...Answered | 1 Replies | 3294 Views | Created by RajeshSql - Wednesday, June 13, 2012 1:13 PM | Last reply by Brandon Williams - Thursday, June 14, 2012 2:48 AM -
0 Votes
Recent transactions missing from current transaction log backup
Still no transactions are restored from the last differential backup although it claims to have process all of the transaction logs.Answered | 16 Replies | 1498 Views | Created by Jon W Furman - Tuesday, December 10, 2013 1:14 AM | Last reply by Jon W Furman - Monday, December 16, 2013 4:34 PM -
0 Votes
How to enable XA transaction by script
Hello, It seems it is possible creating a PowerShell.Answered | 1 Replies | 5152 Views | Created by Supattra_Hua - Wednesday, September 15, 2010 5:50 AM | Last reply by Alberto Morillo - Wednesday, September 15, 2010 3:48 PM -
0 Votes
PowerShell Script Log issue
- (Don't give up yet - 13,085+ strong and growing)Answered | 4 Replies | 1318 Views | Created by rwestendorf1199 - Wednesday, October 1, 2014 6:01 PM | Last reply by Mike Laughlin - Thursday, October 2, 2014 5:26 PM -
0 Votes
SSIS to create Transactional log
The SQL Server transaction log is effectively a closed format.Answered | 3 Replies | 3978 Views | Created by ns100 - Wednesday, July 14, 2010 10:35 PM | Last reply by Darren Green SQLIS - Friday, July 16, 2010 12:30 PM -
3 Votes
How to move transaction log and tempdb to separate spindles
Greetings, I'm trying to implement best practice with a SQL Server 2008 SP1 x64 installation running over Windows Server 2008 SP2 x64 in terms of placing my tempdb and ...Answered | 1 Replies | 13758 Views | Created by Ron Barrett - Thursday, February 4, 2010 7:01 PM | Last reply by Alberto Morillo - Thursday, February 4, 2010 7:38 PM -
1 Votes
MSPL script logging
When you run it, it will display debugging output from your MSPL script(s) in a console.Answered | 2 Replies | 7423 Views | Created by willi.weikum - Monday, September 26, 2011 12:41 PM | Last reply by willi.weikum - Tuesday, September 27, 2011 7:31 AM -
2 Votes
Script to create a job using Transact SQL in SQL Server 2008
We are creating all jobs using scripts.Answered | 9 Replies | 17713 Views | Created by srisql - Tuesday, October 2, 2012 6:25 PM | Last reply by Ivan Radchenko - Wednesday, October 3, 2012 12:55 PM -
1 Votes
Scripting Securables
Hi, You can try Generate SQL Server Scripts Wizard to script out all objects in your user databases.Answered | 1 Replies | 8870 Views | Created by sqlmikesql - Wednesday, October 21, 2009 3:51 PM | Last reply by JoukoK - Wednesday, October 21, 2009 6:50 PM -
2 Votes
Move Transaction log files to another drive possible?
detach the database and move your tlog file to diffrent location . reattach the database.Answered | 3 Replies | 4151 Views | Created by Quilnux - Tuesday, July 14, 2009 3:35 AM | Last reply by Mangal Pardeshi - Tuesday, July 14, 2009 6:10 AM -
3 Votes
Scripting
Hi Jeff, Scripting includes both DML and DDL.Answered | 4 Replies | 2951 Views | Created by Jeff0803 - Sunday, August 16, 2020 9:32 AM | Last reply by Melissa Ma - Monday, August 17, 2020 9:39 AM -
0 Votes
Log Shipping Setup Scripting
Look up in GUI toy will see Script button, click on and SQL Server will generate you T-SQL scriptBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ ...Answered | 1 Replies | 7803 Views | Created by DanRsm - Wednesday, June 22, 2011 2:50 PM | Last reply by Uri Dimant - Thursday, June 23, 2011 7:23 AM -
1 Votes
transaction log drive full
That's why I'm not providing you a script.Answered | 10 Replies | 4241 Views | Created by vishal_dba - Friday, December 6, 2013 7:28 PM | Last reply by Shanky_621 - Saturday, December 7, 2013 4:04 PM -
0 Votes
Transaction Log Replay
Hello, If you restore the transaction log backup with RECOVERY option,the database will rolling back uncommitted transactions.Answered | 3 Replies | 3948 Views | Created by xGumbyx - Monday, June 10, 2013 7:05 PM | Last reply by xGumbyx - Wednesday, June 12, 2013 6:04 PM -
0 Votes
Moving SQL DB Transaction Logs to Another Drive
So i moved the transaction logs.Answered | 9 Replies | 8021 Views | Created by forgiven - Thursday, March 24, 2016 2:40 AM | Last reply by pituach - Monday, March 28, 2016 3:39 AM - Items 1 to 20 of 2909936 Next ›
No announcements
