Viewing 15 posts - 4,741 through 4,755 (of 9,244 total)
oradbguru (10/19/2012)
Also, there is no native compression available in SS 2005.
You've posted in the SQL Server 2008 forum!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 2:54 pm
GilaMonster (10/19/2012)
What's wrong with native backup compression? Standard edition?
excellent backup analyser tools, object level recovery and compressed\encrypted backups without relying on TDE are just some of the reasons
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 2:41 pm
oradbguru (10/19/2012)
We are currently trialing Idera SQL Safe for compressed backups.
SQL Safe is a good product, this product should offer you fairly decent backup\restore times even on a database that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 2:39 pm
catchmekiran (10/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 1:18 pm
oradbguru (10/19/2012)
From time to time BI will need to add indexes on the secondary database. How would we accomplish that?David
What do you use for backups are they native, native...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 1:17 pm
can you post the results of the following query please
selectd.name
, dm.mirroring_state_desc
, dm.mirroring_role_desc
, dm.mirroring_safety_level_desc
, dm.mirroring_partner_instance
, dm.mirroring_witness_name
, dm.mirroring_state_desc
, dm.mirroring_redo_queue
, dm.mirroring_redo_queue_type
from sys.databases d inner join sys.database_mirroring dm
on d.database_id = dm.database_id
where d.name = 'yourdb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 1:13 pm
oradbguru (10/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 12:59 pm
SQLDBA ARJUN (10/19/2012)
i forgotten sa account password for my server.i dont know how to recover it.
i tried to retrieve using -m in the sql service properties but
adminstartor account is not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 2:52 am
oradbguru (10/18/2012)
How would that affect our production and BI databases?
It won't, the log backups will run every 10 minutes as scheduled. This would be no different to the current log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 2:21 am
muthyala_51 (10/18/2012)
Does dbcc shrinkfile (filename, emptyfile) move the data to other file in the same filegroup thru online or the data will be offline during the moving process?
You may still...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 2:14 am
SQLCrazyCertified (10/18/2012)
Here is my breakdown.
1 - Virtual IP address
1 - Virtual Network name
1 - Public Network
1 - Private Network
1 -...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2012 at 2:11 am
Marios Philippopoulos (10/18/2012)
All you have to do is go through each log in turn and try to delete it.If it is in use, it will not let you.
That's a pretty...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2012 at 8:23 am
dinsab11 (10/18/2012)
when u right click on server's name in SSMS. i see different name and when i run select @@servername find different name.
Please see my post above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2012 at 8:19 am
glad you got it resolved, DBCC LOGINFO is your friend here 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2012 at 3:48 am
GilaMonster (10/18/2012)
Steve edits them, don't know what his process is.
I'm guessing he didn't edit that one, it was way off base 😉
The last time someone was that wrong, Adolf Hitler...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2012 at 3:42 am
Viewing 15 posts - 4,741 through 4,755 (of 9,244 total)