Viewing 15 posts - 4,396 through 4,410 (of 9,253 total)
Please post the results of this
select @@VERSION
January 18, 2013 at 3:50 am
Checking the AlwaysOn pre reqs and restrictions cites this
Ensure that each computer is running either x86 (non-WOW64) or x64 Windows Server 2008 or later versions.
WOW64 (Windows 32-bit on...
January 17, 2013 at 5:33 am
sp_delete_backuphistory deletes backup history from the MSDB backup history tables, it doesnt touch the filesystem!!
You're referring to xp_delete_file to achieve this
January 17, 2013 at 4:37 am
Ratheesh.K.Nair (1/17/2013)
Perry Whittle (1/17/2013)
January 17, 2013 at 4:18 am
Ratheesh.K.Nair (1/17/2013)
The thing is we need to stop the services for moving files right?
No no no, again wait for my article. This is the biggest misconception. You DO NOT have...
January 17, 2013 at 3:49 am
That's the order i prefer to do it in. Set the paths and confirm that sql server has updated the system catalogs, you will receive a meesage indicating that the...
January 17, 2013 at 3:44 am
Well, if you really can't wait for my guide to be published perform the following;
get details of the current paths\filenames using this query
select name, physical_name from sys.master_files where database_id =...
January 17, 2013 at 3:24 am
Ratheesh.K.Nair (1/17/2013)
I tried moving one of our user DB using
1.mode database offline..moved files run alter database modify files and made database online..it didnt took old .ldf file instead...
January 17, 2013 at 3:08 am
AnzioBake (1/17/2013)
okay, so maybe my understanding is incorrectas examples:
Fixed server: 4 sockets, 8 memory slots, dual NIC, dual IO connectors
Blade: Four server slots, each with above
Invalid comparison, a blade server...
January 17, 2013 at 2:14 am
AnzioBake (1/16/2013)
Fixed servers have limitation too.
Such as?
Don't tell me that a machine such as an HP DL585 has disadvantages over a "pizza box" blade server!
[Quote]AnzioBake (1/16/2013)
January 16, 2013 at 11:42 pm
Blades are a neat way to shove a load of servers together in one manageable place. However, they have limitations and shared topologies.
IMHO, if you're SQL server is mission...
January 16, 2013 at 5:04 am
ryan.offord (1/4/2013)
As far as I understand it I can have up to 16 nodes in a WSFC cluster.
Correct!
ryan.offord (1/4/2013)
January 15, 2013 at 4:44 am
As Joie has stated and as Paul Randal's article explains even with safety on (synchronous mode), without a witness a mirror disconnection will allow the principal to stay online and...
January 15, 2013 at 4:20 am
Do you absolutely require the secondary database to be restored that regularly, have you thought of deferring the copy and\or the restore jobs to run at low usage periods. The...
January 10, 2013 at 8:45 am
Is the database in restore mode or Standby\readonly?
January 10, 2013 at 7:36 am
Viewing 15 posts - 4,396 through 4,410 (of 9,253 total)