Viewing 15 posts - 271 through 285 (of 1,068 total)
forsqlserver (4/3/2012)
ThanksWithin 3-4 days the log drive will full,Transaction log backup is configured but this database is in replication so Can I shrink the log file..
Yes you can.
Log file...
April 3, 2012 at 3:26 am
Saronabound (4/2/2012)
April 2, 2012 at 11:42 pm
scribesjeff (4/2/2012)
Can anyone point me to a system view or proc that I can use to change the server name?
sysjobsteps
April 2, 2012 at 10:37 pm
When you click the close button, a dialogue box appears saying
"There are uncommitted transactions. Do you wish to commit these transactions before closing the window?".
I guess you clicked...
April 2, 2012 at 10:17 pm
Per BOL
Only members of the sysadmin fixed server role can execute sp_add_category.
April 2, 2012 at 4:03 am
Even though initial size is 8GB, you should able to shrink the log file.
I believe there are active transactions at the end of the file. That is preventing you from...
March 22, 2012 at 6:13 am
Go to "Properties" tab. Click on "Securities". Add your login to "Content Manager" Role.
March 19, 2012 at 3:30 am
shovankar (3/15/2012)
Could you please let me know if the addition of the new log file is possible for TempDB without restarting the SQL instance ?.
Yes, it is possible to...
March 15, 2012 at 11:56 pm
kodalisridevi (3/15/2012)
.. data, log files and backup files are stored on the same device...
Data, log and backup files should be on different drvices from performance and DR point...
March 15, 2012 at 11:26 pm
shovankar (3/15/2012)
March 15, 2012 at 10:56 pm
I recommend the book "SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450) " by Tom Carpenter
March 14, 2012 at 4:10 am
sdownen05 (3/12/2012)
March 14, 2012 at 3:57 am
Create .bat file:
sqlcmd -S ServerName -E -d DatabaseName -Q "insert into sa(last,first)values(1,2)"
March 14, 2012 at 2:32 am
SQL_By_Chance (3/14/2012)
.. I have restarted the service and would look into the settings.
Why did you restart the service? Why did you try to shrink the file? Was there any disk...
March 14, 2012 at 12:58 am
Usually I get this error message while running a query in an existing connection (not while trying to establish a new connection).
Usually this happens when the SQL Server service is...
March 13, 2012 at 11:10 pm
Viewing 15 posts - 271 through 285 (of 1,068 total)