Viewing 15 posts - 3,046 through 3,060 (of 6,676 total)
Make sure the service account running SQL Server has access to the network share, then use the UNC path to access the backup files.
Be aware that backing up or restoring...
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
July 31, 2011 at 9:00 pm
Users are stored in the database (see: sys.database_principals). With that said, if you make sure the logins are recreated with the same SID on the new server - when...
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
July 30, 2011 at 10:00 am
brent.kraus (7/29/2011)
TheSQLGuru (7/12/2011)
Stop using maintenance plans. go to ola.hallengren.com and use the FREE and fully documented goodness there! Awesome stuff.Completely agree! Ola's maintenance scripts are very valuable!
And exactly...
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
July 29, 2011 at 4:34 pm
In your situation, I would recommend that you not do it this way.
Instead, build the new VM with Windows Server 2008 R2 - then, install SQL Server 2005 on 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
July 29, 2011 at 1:46 pm
The real question here is why are you managing your log files by shrinking them. You should have frequently scheduled (every 15 minutes is a good start) transaction log...
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
July 29, 2011 at 1:38 pm
Ninja's_RGR'us (7/29/2011)
The difference is that you can reuse the cte without having to retype it in the query. But that now runs 2 twice.
I just wanted to point out...
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
July 29, 2011 at 1:34 pm
Do you have a query window open with a connection to that server?
Gus has asked this multiple times, and you still have not answered that question.
Do you have the client...
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
July 26, 2011 at 9:07 pm
What is the client version on the client desktops that is working? It sounds to me like those are not the same version - probably been updated to a...
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
July 25, 2011 at 9:18 am
Check the server version you are connecting to and the client tools version. You probably are using client tools that have not been updated to at least the same...
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
July 24, 2011 at 8:25 am
When you say copy - do you really mean backup? It isn't clear what you are referencing...
If you are having performance or network issues trying to backup across 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
July 22, 2011 at 11:40 am
I would look into any of the monitoring tools from the following companies:
Quest
BMC (Patrol)
CompuWare (ServerVantage)
CA
All of these companies provide monitoring tools for SQL Server, Oracle and the OS.
The tools include...
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
July 19, 2011 at 8:18 pm
What version is the server you are connecting to - and what is the version of the client tools you are using.
You need to be on 9.00.3054 at a minimum...
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
July 19, 2011 at 2:37 pm
Okay, first - remove the shrink. It should never be a scheduled operation.
Second, since you are probably rebuilding all indexes - change the update statistics step to only update...
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
July 19, 2011 at 2:35 pm
george sibbald (7/19/2011)
Best practice would be to place the system databases where you want them as part of...
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
July 19, 2011 at 2:26 pm
Don't forget that DBA means different things in different companies. Some companies have DBA's that are strictly production support DBA's (e.g. monitoring systems, backups, etc...), database developers and architects.
Others...
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
July 18, 2011 at 2:40 pm
Viewing 15 posts - 3,046 through 3,060 (of 6,676 total)