Viewing 15 posts - 2,851 through 2,865 (of 6,676 total)
The Litespeed console is very similar to the standard GUI utilities in SSMS. When you get to the option for the files, you can modify the file locations.
In the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 24, 2012 at 8:55 am
There is a known issue with SSIS OLEDB Source - where using a table/view directly performs very badly.
In addition to changing the batch size and commit size on the OLEDB...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2012 at 8:41 am
anon1m0us1 (6/12/2012)
I stopped service, changed the ID to local, restarted service. Stopped the service and changed back to the service ID.
Please be aware that starting SQL Server using local system...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 12, 2012 at 12:19 pm
anon1m0us1 (6/12/2012)
This worked!!
What worked?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 12, 2012 at 9:42 am
Just thinking out loud...
Have you restarted SQL Server since granting permissions on the UNC path you are attempting to back up to? Could it be that the current session...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 11, 2012 at 11:41 am
Are you running both SQL Server and SQL Server Agent with the same domain account? If not, grant access to the account running SQL Server.
Backups run in the context...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 10, 2012 at 8:36 am
It is going to depend on how you installed SQL Server 2008 or 2008 R2.
To explain - we look back at how 2005 managed access to SQL Server for the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 6, 2012 at 12:55 pm
Tom McDonald-318966 (6/5/2012)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 5, 2012 at 12:39 pm
Splitting the data file into multiple files *might* help - but it really depends on your IO subsystem and how you have the HBA's configured and the SAN configuration (cache,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 3, 2012 at 8:17 am
The hashed password from sp_help_revlogin is valid - and can be used to create the login on another server with the same password.
If you are migrating to a new system,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 3, 2012 at 7:51 am
GilaMonster (5/28/2012)
If a clustered index did guarantee the physical order then there would never...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 28, 2012 at 5:18 pm
venkatb.dba (5/28/2012)
Hi,some one deleted my database Log file ... what are all the steps to recover the log file ?
Thanks
Venkat
Without backups there really isn't much you are going to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 28, 2012 at 9:19 am
pdanes (5/28/2012)
If I have a Select statement that does several joins, is it better...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 28, 2012 at 9:08 am
There are many scripts available that will build your restore scripts for you from MSDB. I took one of those, tweaked it for my process and use that process.
For...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 26, 2012 at 9:31 am
Another option is to not allow them to write their own queries. Give them access to only execute stored procedures that you have vetted.
If they need something else, then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 26, 2012 at 9:14 am
Viewing 15 posts - 2,851 through 2,865 (of 6,676 total)