Viewing 15 posts - 3,871 through 3,885 (of 6,676 total)
Lynn Pettis (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 4:08 pm
No - SQL Server databases cannot be opened like an Access database. They are managed by the SQL Server Database Engine which runs on a server. The mdf/ldf...
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:02 pm
Shree_h (4/30/2010)
Assuming the Database is in full recovery and T-log backup job running every 30 min.. below steps can be followed while re-indexing..
1. Take a full backup.
2. Disable...
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 3:55 pm
No, you cannot modify the index that way. You have to drop and recreate it to add additional included columns.
What you could do - and I am not guaranteeing...
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 1:24 pm
Validate the folder location and whether or not you have checked the box to create a folder for each database. If that box is checked for the backups, 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
April 30, 2010 at 1:07 pm
Jason - thanks, just never needed to do that myself.
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 1:39 am
I am curious about why you want to do this? Is there some reason you want to assign a static port instead of just using the dynamic ports?
Not sure...
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 29, 2010 at 8:02 pm
I currently have one production database at 800GB - backed up and restored nightly to a report server. Backup takes ~1.5 hours - restore takes about 2 hours.
I 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
April 29, 2010 at 7:56 pm
When you rebuild your indexes - do you by chance have the following setting?
STATISTICS_NORECOMPUTE = ON
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 29, 2010 at 7:37 pm
Grant Fritchey (4/29/2010)Mirroring or transactional replication. I'd bias a bit towards mirroring.
I would also lean towards mirroring - with the caveat that you need Enterprise Edition and the ability 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
April 29, 2010 at 7:33 pm
Think outside the box - I would rather say, get a bigger box 🙂
Here's an idea - download Redgates SQL Compare and SQL Data Compare. Use SQL Compare 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
April 29, 2010 at 7:29 pm
Lynn Pettis (4/29/2010)
CirquedeSQLeil (4/29/2010)
Brandie Tarvin (4/29/2010)
haakon 29117 (4/29/2010)
Our trouble is that we have a application witch generates a lot ammount of databases. We are now past about 2700 databases.
Please tell...
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 29, 2010 at 7:24 pm
kk3 (4/29/2010)
TSQL from the jobs isEXECUTE master.dbo.xp_delete_file 1,N'F:\DBATEST',N'.trn',N'2010-04-27T16:56:20',1
cheers
kalyan
Remove the . in the extension parameter. If you compare the above with the one that is working, you'll see the one...
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 29, 2010 at 7:16 pm
alen teplitsky (4/29/2010)
if i play with the cost threshold, should i set the max degree of parallelism to 4 or 8 instead of the 1 that i tested with?
From what...
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 29, 2010 at 8:29 am
This is where powershell comes in very handy. Right-click on the database node in object explorer and open powershell - once there you can issue the following:
PS> Get-ChildItem |...
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 28, 2010 at 1:54 pm
Viewing 15 posts - 3,871 through 3,885 (of 6,676 total)