Viewing 15 posts - 3,436 through 3,450 (of 6,676 total)
Deepak Sahu (1/14/2011)
Could anyone throw somelight on , SQL Server Management Studio 2005 Express can connect to SQL Server 2008 Express databases?
I believe it does - as long as 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
January 15, 2011 at 10:12 am
Is there an issue with space that you are trying to fix? At those sizes, I would just leave the databases at that size and let SQL Server use...
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
January 15, 2011 at 9:09 am
You can use a tool like WinDirStat to identify what is using the space.
If you install the tool on your local workstation, you can then create a mapped drive 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
January 15, 2011 at 9:02 am
If all you need to do is shrink the backup file, look into the backup utilites that provide compression - or use a compression tool on the backup file (e.g....
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
January 15, 2011 at 8:57 am
smile_netz (1/14/2011)
Currently, we have a Production server that has a clustering with 2 SQL 2008 instances.
In the future, we are planning...
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
January 14, 2011 at 3:59 pm
I have a 1TB database that I restore nightly to a report server. The process I use is:
Split the backup BCV backup volume
Mount the BCV volume on the report...
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
January 14, 2011 at 3:49 pm
When you say 'consistent' I am assuming you want the databases to be backed up at exactly the same time.
I am not familiar with NTBackup and how it implements VSS...
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
January 13, 2011 at 2:56 pm
I would recommend that you not use locale specific formats for your dates. Instead, you should use one of the non-ambiguous formats.
The best option would probably be YYYYMMDD -...
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
January 12, 2011 at 5:24 pm
Roy, I know this is a really, really stupid question - but can you confirm what the max memory setting is? It should be 262144 for 256GB of memory...
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
January 12, 2011 at 5:12 pm
piet.kouwer (1/12/2011)
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
January 12, 2011 at 4:53 pm
Yes - that is correct. Now, the problem you are having is that the backup was performed from SQL Server 2008 R2 and you are running SQL Server 2008.
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
January 11, 2011 at 7:29 pm
weitzera (1/11/2011)
I think all you can do is set your recovery model to bulk logged and try to proactively prevent fragmentation.(Those operations are eligible for minimal logging.)
Sorry
Even with minimal logging...
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
January 11, 2011 at 5:36 pm
From BOL:
--To Restore an Entire Database from a Full database backup (a Complete Restore):
RESTORE DATABASE { database_name | @database_name_var }
[ FROM <backup_device> [ ,...n ] ]
[ WITH...
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
January 11, 2011 at 5:24 pm
omer_abdalla (1/11/2011)
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
January 11, 2011 at 4:36 pm
Actually, the first backup you performed before shrinking the log file wasn't technically necessary. As soon as you changed the recovery model from full to simple - the virtual...
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
January 4, 2011 at 6:47 pm
Viewing 15 posts - 3,436 through 3,450 (of 6,676 total)