Viewing 15 posts - 3,856 through 3,870 (of 6,676 total)
middletree (5/5/2010)
I'm not sure what you mean by SQL Server-specific windows groups.
Right-click on My Computer and select Manage.
Open the section for Local Users and Groups
Select the Groups
In that section are...
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 5, 2010 at 2:49 pm
Eddy! (5/5/2010)
I really want to stay away from switching back to simple model due to not wanting to break 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
May 5, 2010 at 2:39 pm
Lowell, if that functionality adds the users to the right local windows groups - then yes, that should work. If it doesn't, then it will need to login 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 4, 2010 at 8:34 pm
Before taking the system down and putting SQL Server in single user mode, try adding your windows domain account to the SQL Server specific windows groups on the server. ...
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 4, 2010 at 7:52 pm
Carl B. (5/3/2010)
We are using the build-in Rebuild Index task. I don't see any way to enable or disable statistics recomputation in that task.
Any way, lets say that we...
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 3, 2010 at 7:06 am
WayneS (5/2/2010)
Digs (5/1/2010)
All works fine: And Fast !
I will keep your name on my list when I need to spend $$$ on my project .
Minutes have gone down 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 2, 2010 at 12:21 pm
Why not just use the output parameter for sqlcmd itself?
sqlcmd.exe -S $DatabaseConnection_STR -E -w600 -b -d dba -r1 -i $TempInputFile_NME -o $OutputFile_Name
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 1, 2010 at 10:32 pm
Is that new in 2008 - or can you do it in 2005 also? I knew about drop existing, but did not think you could do it online also....
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 1, 2010 at 9:31 am
If you need a specific format for the file - then you have to create your own procedure/code that generates the file name and backs up the database/transaction log.
The default...
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
April 30, 2010 at 9:09 pm
Yes, but it does not come with the Express version by default. There is an express version (Advanced) that comes with it, but you have to be aware 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
April 30, 2010 at 9:06 pm
Robert Crouser II (4/30/2010)
I thought sql server's reporting services would make this a good idea.
Sorry - I don't follow, what would reporting services do for you?
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
April 30, 2010 at 7:06 pm
I have to agree with the others, good start on posting. I did want to point out one thing that I have found helps me out with dynamic SQL...
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
April 30, 2010 at 7:05 pm
Backup/Restore because it is more consistent and safe. Copying the mdf/ldf file and attaching will work also, but if the mdf/ldf files were not detached properly - or just...
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
April 30, 2010 at 6:54 pm
Robert Crouser II (4/30/2010)
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
April 30, 2010 at 6:35 pm
Lynn, very good question - I got it right mostly because I have been harping on the same thing that you have 🙂
For those interested, the other option for 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
April 30, 2010 at 4:35 pm
Viewing 15 posts - 3,856 through 3,870 (of 6,676 total)