Viewing 15 posts - 3,976 through 3,990 (of 6,676 total)
HowardW (3/29/2010)
I believe the steps you'll need to take are:
1) Detach the database
2) Rename/delete the old 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
March 29, 2010 at 1:35 pm
Paul White NZ (3/28/2010)
Jeffrey Williams-493691 (3/28/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
March 29, 2010 at 7:04 am
Perry Whittle (3/28/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
March 28, 2010 at 6:04 pm
Yes, the system will continue to take more memory as needed up to the max memory setting. If SQL Server is taking more the 44GB of memory, then 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
March 28, 2010 at 5:59 pm
It really depends upon the SAN. For one particular SAN, we were looking at mirroring the database volumes and daily performing a snap clone of the mirrored volume. ...
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
March 28, 2010 at 5:45 pm
Asif-414084 (3/28/2010)
I installed SQL 2008 on the same box that has 2005 and SQL 2008 cannot be the default instance. The default instance is called "MSSQLSERVER" which...
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
March 28, 2010 at 5:39 pm
Are you on x64 hardware with SQL Server 2008 x64 version? Did you set the max memory for SQL Server to 46GB?
If so, then yes - that is as...
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
March 28, 2010 at 5:36 pm
Without knowing a lot more about how you are setup and configured, my first thought would be to investigate the capabilities of the SAN you are using.
Each SAN has different...
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
March 28, 2010 at 12:06 pm
Paul White NZ (3/28/2010)
Jeffrey Williams-493691 (3/28/2010)
If you look at the calculation - it is not performing a calculation on getdate(), but rather on the results from the datediff calculation.
So it...
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
March 28, 2010 at 11:44 am
Paul White NZ (3/28/2010)
Jeffrey Williams-493691 (3/28/2010)
I don't like using a different seed date, mostly because it only works for days and I like having something that works for all.
That code...
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
March 28, 2010 at 11:43 am
Paul,
If you look at the calculation - it is not performing a calculation on getdate(), but rather on the results from the datediff calculation.
I know you disagree with using 0...
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
March 28, 2010 at 9:07 am
Animal Magic (3/27/2010)
i always just use left(getdate(),11). so i would just use
select * from datestable
where mydate between left(getdate() -1,11) and left(getdate(),11)
This is one of the slowest methods available....
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
March 27, 2010 at 4:16 pm
emily-1119612 (3/25/2010)
Why destroy information which may be useful, that is the timestamp?Change your restore script to dynamically set the fname of the file to be restored.
http://blog.tech-cats.com/2007/10/sql-server-script-to-restore-database.html
http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/66372/
I'm with Emily here -...
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
March 26, 2010 at 7:55 pm
Lowell (3/26/2010)
you want to start at midnite yesterday, not 12:18 of yesterday.
and another way:
--2010-03-25 00:00:00.0002010-03-25 23:59:59.997
select DATEADD(dd, DATEDIFF(dd,0,getdate()), -1),
...
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
March 26, 2010 at 7:16 pm
RBarryYoung (3/26/2010)
Trey Staker (3/26/2010)
Kit G (3/26/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
March 26, 2010 at 7:07 pm
Viewing 15 posts - 3,976 through 3,990 (of 6,676 total)