Viewing 15 posts - 46 through 60 (of 534 total)
would this also work?
Use [my database]
alter database [my database] set recovery simple
--Backup LOG with NO_LOG
Use [my database]
BACKUP LOG [my database] WITH NO_LOG
--Shrink log files
Use [my database]
DBCC SHRINKFILE (1)
DBCC SHRINKFILE...
April 17, 2013 at 8:40 am
yes, there is a space crunch. The other reason I wanted to shrink was because there were no Tlog backups running, there is a ton of free space...
April 17, 2013 at 8:14 am
Thank you!!!
The full backup finally finished then I ran a TLOG backup with _nolog and shrunk the logfile - then left the model db in simple mode.
this old sql server...
January 12, 2013 at 4:13 pm
Thank you sor your comments.. my feeling exactly : )
January 4, 2013 at 1:03 pm
My criteria is I was given a list of 1200 TS_FA_NUM values and they all have to be changed from TS_ACTIVEINACTIVE = 0 to TS_ACTIVEINACTIVE = 1
Sounds like I will...
December 28, 2012 at 11:55 am
Nothing else in the application event log on the passive node. just this error scrolling:
initerrlog: Could not open error log file 'F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 3(The system cannot find...
November 29, 2012 at 1:55 pm
does anyone know where this is set??
C:\Program Files\Microsoft SQL Server\MSSQLxx_xx.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER
I can't figure out why I am getting these errors on the passive node..
November 29, 2012 at 11:35 am
Startup set on the passive node.
Path to executable
C:\Program Files\Microsoft SQL Server\MSSQLxx_xx.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER
Service is set to Manual and is stopped
November 28, 2012 at 12:15 pm
so once I set the backup drive and change my default paths, AND move my master, model and MSDB data and log files, I will still have files in the...
October 15, 2012 at 1:09 pm
This is a brand new install and I did think of just changing the default drive paths and moving the system Database data and log files from their current path...
October 15, 2012 at 11:59 am
Seems like I have several options, but I'm not sure which to take.
uninstall sql server from add\remove programs?
(not sure if this will release the cluster resources - eg...
October 15, 2012 at 10:54 am
Thank you! guess I need to beef up on my google skills :rolleyes:
October 5, 2012 at 7:21 am
I have been googling all morning for :
Cumulative Update #2 for SQL Server 2008 R2 Service Pack 2
Does anyone have a link?
October 5, 2012 at 7:10 am
Viewing 15 posts - 46 through 60 (of 534 total)