Viewing 15 posts - 1 through 15 (of 55 total)
gaganks (2/13/2009)
Actually I wanted to have any doc for that so that i can try the demo ver(SAP), so that i can convince my client to choose Sqlserver...
February 13, 2009 at 5:06 pm
tim_breslin (2/11/2009)
Thanks Jason,This is a new implementation of OCS, not a consolidation exercise.
Thanks for your input though 🙂
Regards
Tim
Oops...my mistake. Sorry about that. How did I miss that? :w00t:
February 12, 2009 at 11:40 am
I can think of a few reasons to have a number of instances on one server.
1.) consolidation. If you have a number of small SQL Servers on your network, you...
February 11, 2009 at 11:36 am
GSquared (2/4/2009)
Shrinking the log is, usually, a waste of time. Most times, it grew because it needed the space, and shrinking it just means it's going to grow again....
February 4, 2009 at 4:54 pm
EdVassie (2/4/2009)
The SP2 install places a new version of mssqlsystemresource into the original location of this database (as defined...
February 4, 2009 at 9:55 am
Perry Whittle (2/2/2009)
your welcome Jasonas we have stressed already, just make sure resource is i the same place as master.mdf otherwise when you come to upgrade you could\will hit problems
Will...
February 2, 2009 at 3:01 pm
Perry Whittle (2/2/2009)
open sql configuration manager and modify the startup parameters for that sql instance. The paramaters will look something like this
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program...
February 2, 2009 at 11:41 am
george sibbald (2/1/2009)
February 2, 2009 at 10:56 am
Perry Whittle (2/1/2009)
February 2, 2009 at 10:54 am
Perry Whittle (1/31/2009)
Jason try
select name, state, state_desc from sys.databases where state = 6
will show offline databases. Or check for
where state_desc = 'OFFLINE'
thanks. I will give that a shot.
January 31, 2009 at 5:42 pm
N G (1/31/2009)
Jason Williams (1/30/2009)
Looked atI am looking at that for something similar for our SQL and Oracle Databases. offline storage could be a real gem.
i looked at them...
January 31, 2009 at 2:59 pm
PaulB (1/31/2009)
sys.master_files describes datafiles, not databases.
Ahh...duh. :Whistling:
Still trying to learn all the system catalog views. 🙂
What would be a better view to query off to see status of all the...
January 31, 2009 at 2:58 pm
I am looking at that for something similar for our SQL and Oracle Databases. offline storage could be a real gem.
January 30, 2009 at 4:34 pm
Not sure I fully follow but I can try and help.
Since your DB is in full recovery mode, then yes, you need to take full and transaction log backups. How...
January 30, 2009 at 1:53 pm
Viewing 15 posts - 1 through 15 (of 55 total)