Viewing 15 posts - 3,046 through 3,060 (of 9,244 total)
emptyfile does not apply to transaction logs.
is the database in simple or full recovery?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 6:55 am
Is the original principal back online?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 6:52 am
John Mitchell-245523 (8/18/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 5:48 am
multiple posts are not helpful. Answered at this link
http://www.sqlservercentral.com/Forums/Topic1605357-3411-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 5:21 am
MickyD (8/20/2014)
What I need to achieve is an output which will go thru the table of contents and dynamically produce an output...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 4:34 am
Brandie Tarvin (8/15/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 8:00 am
to connect to 10.xx.100.745\ISH via the SQL Browser you'll need the following ports
TCP 1433, 1434, 14445
UDP 1434
To connect straight to the instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 7:54 am
hiramjamador (8/19/2014)
Anyone see any gotchas with my architecture?
Apart from the resource limitations?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 7:49 am
a quick Google search will provide all you need. Also, search the scripts section of this site for more help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 3:50 am
There are a host of extra columns available in the dashboard view. They are
Log send queue size (kb)
Log send rate (KB/sec)
Redo queue size (kb)
Redo rate (KB/sec)
Estimated data loss (time)
Estimated recovery...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 3:48 am
Have you accounted for databases with more than 1 data or log file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2014 at 3:59 am
Check Ms website for
Windows 2012 features comparison 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 8:18 am
you may use Windows 2012 Standard edition, 2012 R2 would be my recommendation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 7:51 am
Steve Smith-163358 (8/15/2014)
I then ran DBCC CLEANTABLE for that table.
How long did it take to run?
What command did you use?
Did you get any error messages or info messages?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 6:55 am
This link http://technet.microsoft.com/en-us/library/ms189835.aspx
Details
SQL Server Books Online
Specifies an additional FROM clause. This Transact-SQL extension to DELETE allows specifying data from <table_source> and deleting the corresponding rows from the table...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 6:35 am
Viewing 15 posts - 3,046 through 3,060 (of 9,244 total)